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

Hi,

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.
Excel-

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)

Thank you.:slight_smile: it’s working

Please Mark it as a solution and close the topic.

Thanks…