Batch macro Setup

[akvsachin]

Hi I'm stuck at the point. I need my api, key and secret to run for multiple ids with an access token for those api to fetch the workflows name/id those Collection_Ids are associated with.
That would be needed to done iteratively through batch macro, but how to use those id in formula tool in batch macro workflow.

Batch Macro Text Input Tool : URL, KEY, SECRET
Batch Macro Input Anchor : ID, OWNER_ID, DATE_MODIFIED, C_ID(Grouped By)
Batch Macro Formula Tool : I need is URL/ID/

[akvsachin]

Hi @OllieClarke @atcodedog05 

I'm going through deadline, if anyone can help me through

Suppose headers are as

| id | name | workflowid_1 | worflow_2 | ... workflowid_255 |

| id1 | xyz | null | 56asd78af | 89afusd | 89asdc | null | ....| null |

| id2 | ghi | 89vad | null | null |... | null |

| id3 | bhu | 98uzvdvu | null | null | ... | null |

I need the records as

| id1 | xyz | 56asd78af |

| id1 | xyz | 89afusd |

| id1 | xyz | 89asdc |

| id2 | ghi | 89vad |

| id3 | bhu | 98uzvdvu |

[OllieClarke]

Hi @akvsachin use a transpose tool with ID and Name selected as key fields, and all other fields (including 'dynamic or unknown columns') selected as data fields.

Then filter out the rows where value is empty.

Hope that helps,

Ollie