File Read helpHi, Below is the sample CSV file and like this i have 200*1000 records minimum.
i need to read this and group by RefID
ID RefID Data
100, 1, sample1
100,1,sample2
100,1,sample3
100,1,sample4
100,2,sample1
100,2,sample2
100,2,sample3
100,2,sample4
100,2,sample5
100,3,sample1
100,3,sample2
100,3,sample3
The expected output which has to be sent to backend below
100,1,sample1|sample2|sample3|sample4
100,2,sample1|sample2|sample3|sample4,sample5
100,3,sample1|sample2|sample3
what is the best and fastest way to read the csv file and group based on RefId and make the data as pipe delimited. any sample would be highly appreciated