Need column data in string with comma saperated

Help Studio
, , , , ,
1

Hello,

i have below data in excel

image
image170×223 1.78 KB

I need to get only those user names where value for SNCF column is “yes” and need to save all user names in one variable with comma saperation
like below

ABC,PQR,GHD,BFD,GGF (ASD is not there as value is “no” in SNCF)

help me on same

2

Hey @Mathkar_kunal

Use Assign Activity:

String.Join(",", dt_Input.AsEnumerable().Where(Function(y) y("SNCF").ToString.Trim.ToLower.Equals("yes")).Select(Function(row) row("Users").ToString.Trim()).ToArray())

The image shows a UI workflow with an assignment step creating a username string from a data table and a log message step to display the processed usernames. (Captioned by AI)
The image shows a UI workflow with an assignment step creating a username string from a data table and a log message step to display the processed usernames. (Captioned by AI)1184×180 6.17 KB

Happy Automation!

Best regards,
Ajay Mishra