Need column data in string with comma saperated

[Mathkar_kunal]

Hello,

i have below data in excel

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

[Ajay_Mishra (Ajay Mahendra Mishra)]

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())

Happy Automation!

Best regards,
Ajay Mishra