Download Tool formatting API results in Cross Tab - Batch Macro needed?

I have a SQL stored procedure input that produces multiple API strings needed for a Download tool.

The remaining part of the workflow formats the results into a table like format using the 'Text to Columns' and 'Cross Tab' components:

As per above it works fine if there is one 'Project ID' but I get multiple field values in the output if more than one:

Any ideas how I can resolve? Just wondering if I need to set but a batch macro to loop through each SQL row and and trigger the workflow for each API individually? All help appreciated!

Batch Macro

Accepted answers

jrichardson

Thanks for the quick response - appreciate it. Yes that has indeed split out the records into separate columns and rows but I now have additional NULL rows so will look to filter these out and it should consolidate down as expected I think:

All comments

BrandonB

I would suggest adding a record ID tool before your crosstab and grouping by the Record ID as well when you are crosstabbing. This will make sure that each row of data pre-crosstab is treated as an individual group. Should be a relatively quick fix for you.

jrichardson

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703