Can't Split PAD DataTable into two other DataTables

(0) Share

Report

Posted on by user42

Hi folks, I have a scenario I'm stuck on and am asking for some help please.

Problem

I have 3 PAD Data Table variables: %BatchItems% %DataTableExclude% %DataTableInclude%.
%BatchItems% has records, the other two are empty by design.
I am struggling splitting the records from %BatchItems% into the other two tables.
The criteria for any record to be put into %DataTableExclude% is that any record that has Field1, Field2, AND Fiel3 set to empty string/null.
- This is where I'm stuck.

Attempted

I'm trying to do this with either a "Run PowerShell Action" or a "Run .NET script" method, but have been unable to get either to work.
I couldn't think of a PAD native way to do it, but would love to be proven wrong.

Does anyone have any advice on how to tackle this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@user42

Could you please provide some screenshots of your Excel file with some example? It would be helpful to see how it looks before splitting and how you'd like it to appear after the split. If possible, include some sample values for clarification.

Was this reply helpful? Yes No
user42 52 on at

Like (0)

Report

Sure @Deenuji, here are some more details:

The data comes from an HTTP-Request that is handled by a "Run PowerShell script" action.
This works fine and populates the PAD DataTable variable %BatchItems%.

Here is %BatchItems% populated after the HTTP-Request:
:

From there, I'm trying to split that data into the two PAD DataTable variables %DataTableInclude% and %DataTableExclude%.

This is how they are created before I attempt to split the records.

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

Could a simple For Each not do it?
If the three fields are empty, add the row to Exclude, otherwise add it to Include?
I have used this method many times.

Was this reply helpful? Yes No
user42 52 on at

Like (0)

Report

Yes, that would work, but can be slower. I was trying to handle it via script to speed up the process.

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

How many rows are we talking about ?

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

Does the http request return all data in one go or is it possible to select what data you want?
383 rows, are moved pretty quickly any way.

Was this reply helpful? Yes No
user42 52 on at

Like (0)

Report

@Highboy 300 or so rows are about average, but it needs to be near real time.

Was this reply helpful? Yes No
Verified answer

user42 52 on at

Like (0)

Report

Thanks for the help guys, but I resolved the issue with my scripting attempts.

Was this reply helpful? Yes No