How to group rows of a particular column data by separating "," and pass the variable into SQL Query


Can anyone please help me how to group rows of a data by separating by" ,".
Below is my scenario. I have an excel data and query.


I want to join all Serial numbers by separating “,”(Example - (‘FK16039051’,‘B160255838’,‘B160977519’). and pass them in to the below Query

AND TD. AssetNumber IN (‘SN1’,’SN2’,’SN3’,’SN4’,’SN5’)) A WHERE A.LedgerNo IN (65,42,34,70);

Thank you.

hi @anuradha_puligoti

you can try attached xaml

Thanks…Test_Excel.xaml (9.2 KB)

1 Like

Thank you.:slight_smile: it’s working

Please Mark it as a solution and close the topic.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.