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

[jrichardson]

Hi 

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!

[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 · Accepted solution]

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: 

[jrichardson]

I have managed to pull the results onto one line by using more record ids and joining the results - thanks for your help!