Apply to Each object/string in a union (Compose)

Like (0) Share

Report

Posted on 9 Apr 2021 16:20:32 by dwalker97

I have got unique rows from column 'InquiryID' by a union expression in Compose step.

I now want to loop through each of these unique ID's by using the output of this compose, but I have not found the correct way to.

This is what my steps look like, when ran they work correct and give the correct output -

I would like to reference each individual ID in a for-each loop as I will be cross-referencing these with another table. How do i reference each item of this union?

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

dwalker97 82 on 14 Apr 2021 at 11:02:57

Like (0)

Report

Re: Apply to Each object/string in a union (Compose)

Perfect, that worked.

Thanks!

Was this reply helpful? Yes No
Verified answer

Paulie78 8,416 Moderator on 09 Apr 2021 at 16:47:01

Like (1)

Report
Re: Apply to Each object/string in a union (Compose)

create a for each loop with your union as the source and you can reference it within the loop using:

item()['InquiryID']

As you only have one property in your array, you can make it even easier by putting the select action into text mode, and the put the InquiryID into the map. Then you will have a plain array of InquiryIDs, then perform your union again.

If you do that, in your apply/each, it will simply be item()

Was this reply helpful? Yes No