Pivot in Load Editor

[nickmarlborough]

Hi, 

I have a table:

ID ------------------------------- Name

ID1 ------------------------------- Nick

ID1 ------------------------------- James

ID1 ------------------------------- James

ID2 ------------------------------- Alex

ID2 ------------------------------- Nick

ID3 ------------------------------- Oliver

I would like to get it so its

ID ------------------------------- Name

ID1 ------------------------------- Nick ; James

ID2  ------------------------------- Alex ; Nick

ID1 ------------------------------- Oliver

How can i do in Load editor?

[PhanThanhSon]

Hi,

try this:

TEMP:
LOAD Distinct *;
Load *,
SubField(Data, '-', 1) AS ID,
SUBFIELD(replace(Data, '-', ' '), ' ', 34) AS Name Inline [
Data
ID ------------------------------- Name
ID1 ------------------------------- Nick
ID1 ------------------------------- James
ID1 ------------------------------- James
ID2 ------------------------------- Alex
ID2 ------------------------------- Nick
ID3 ------------------------------- Oliver
];

NoConcatenate
Data:
LOAD distinct ID,
 CONCAT(Name, ' ; ') AS Name
Resident TEMP  
 Group by ID;    
Drop Table TEMP;

Best regards Son