build a string for each iteration

arkiboys 9,686 Reputation points
2022-04-19T10:18:44.687+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,865 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,427 Reputation points Microsoft Employee
    2022-04-20T00:23:35.657+00:00

    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


0 additional answers

Sort by: Most helpful