I had a similar issue here, but I don't understand how to proceed.
My table has (after an outer join to avoid too much tables(don't know if this matters)) three rows, one row is the productID, the second is the labelID and the third is 'text'.
'text' is the labeltext and the content could be one up to four labels.
There are round about 300 rows. So can I create a similar command as listagg?
I have absolutly no clue of this function. Is there an example to analyze how it works?
Try some script like the following:
LOAD * Inline [
LOAD *,SubField(AllCustNo,',',1) as CustNo1,SubField(AllCustNo,',',2) as CustNo2,SubField(AllCustNo,',',3) as CustNo3;
LOAD Customer,Concat(CustNo,',') as AllCustNo Resident A Group By Customer;
DROP Field AllCustNo;
This is good at mapping to different columns but I would like the values of each row to be within the same cell.
The Listagg is the function I would have used in SQL, I was wondering if there is a build in equivalent?
Tresesco, I am unsure how you would use concat here? Could you please show an example?
The only way I can do this is
but when completing for 20+ rows it gets very wordy and untidy.