How to make string comma saperated after filtering

Help Studio
, , , , , , , ,
1

Hello,

my requirement is i am fildtering user id from wxcel with stus " wrong user id" later i need to update them all in on e string comma ssaperated.check below ss-

image
image162×130 1.87 KB

i am filtering this using filter data table and then using out put data table to convert to string but need comma saperated.

required output -
antovija,x-abcd

2

@Mathkar_kunal After your Filter Data Table (let’s say output is filteredDT), use an Assign activity:

resultString = String.Join(“,”, filteredDT.AsEnumerable().Select(Function(row) row(“Users”).ToString))

replace “Users” with your actual column name if needed.

Output: antovija,x-abcd

Please let me know if it works or not

3

Hi @Mathkar_kunal

Try after filtering the rows where the second column has “Wrong UserID”,
in assign activity use below expression-

commaSeparated = String.Join(“,”, filteredDT.AsEnumerable.Select(Function(r) r(“User Users”).ToString))

This will automatically join all matching user IDs into one string, for example:
antovija,x-abcd,user1,user2…

Happy Automation