Yes, Here you go
LOAD * inline [
] (delimiter is '|');
LOAD SalesGroup,Concat(Team,',') as TeamConcat1 Resident TeamData Group By SalesGroup;
LOAD SalesGroup & '(' & TeamConcat1 & ')' as Final Resident Concat1;
I tried as you suggested but I am getting the repetition of 2nd dimension with 1st dimension.
Column2 showing like A11,A11,A11,A11,A11,A11---------------- against Agriculture.
What i did is like:
Load the whole table 1st.
Column 1, concat(column2,',') as COLUMN2,
sum(amount) as AMOUNT,
group by Column1;
Please suggest, What I did wrong?
I am facing some problem during setting the concatenation in existing script and not getting the exact result. So I go with the Antonio Mancini suggestion, as per his suggestion we don't need any change in the script.
But thanks for your suggestion.