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

[anuradha_puligoti]

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.

[shaikmdrafi (shaik mahammad raphi)]

hi @anuradha_puligoti

you can try attached xaml

Thanks…Test_Excel.xaml (9.2 KB)

[anuradha_puligoti]

Thank you. it’s working

[shaikmdrafi (shaik mahammad raphi)]

Please Mark it as a solution and close the topic.

Thanks…