build a string for each iteration

Question

what is the best way to pull the companyName fields from a .json file and pass them all in a string like?

... and companyName in ('companyName1', 'companyName2', 'companyName3',...)

At present, inside a dataflow, I get the
1- companyNames into a csv file with one columns
2- in pipeline, using a lookup, I get all the companyNames from the csv
3- inside a foreach activity, iterate through each companyName and process each one individually. For example, rather than building the above string, this is what I do at present:

... and companyName = companyName1
and then process the data retrieved from this string
Then on the next iteration,
... and companyName = companyName2
and then process the data retrieved from this string
Then on the next iteration,
... and companyName = companyName3
...

Question:
How can I build the OR string mentioned above?

Thank you

Answer 1

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

Similar ask has been answered here in this query - append variable

Hope this helps. Please let us know if the ask is different from the other thread.

Thank you