I have a collection where I have two columns
1 - WorkerName
2 - WorkerNumber
The workerNumber column has data which I want to be converted/transformed into a comma separated value.
Data in collection:
And output needed is like : 003616,003622,003680.
The idea is to parse this comma separated string as a parameter to run flow.
And that Flow will be parsing this string as "IN" operator of SQL.
I have figured the flow part already, just need some assistance with generating this comma separated string.
Looking forward to awesome response as usual.
Solved! Go to Solution.
@gabibalabanThanks man it worked perfectly 🙂
I wasn't aware of this function before this.
Went a little ahead of this and trimmed the extras 🙂
Set(WorkerNumCSV, Match( Concat( ManagerHierarchyColl, WorkerNumber & ", " ), "^(?<trim>.*), $" ).trim );
Thanks again 😄