Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table Sample with data stored like below in excel spreadsheet.
I need to process the data and store it in the QVD file for further calculations. Appreciate any inputs.
Try using subfield function here:
LOAD Id,
SubField(String, ',') as processedrows
FROM Source;
Try
Subfield(processdrow,',',chr(10))
Check out the sample
Table:
LOAD Id,
SubField(String, ',') as processedrows;
LOAD * INLINE [
Id, String
1, "abc,def,ghi"
2, "jkl,mno,pqr"
];