Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to load following type of excel data.....
Column1 Column2 Column3
ABC A1 B1
A2 B2
A3 B3
XYZ X1 Y1
X2 Y2
Please reply me ASAP
The following script will work.
LOAD If(len(Trim(Column1))=0,Peek(Column1),Column1) as Column1, Column2, Column3;
LOAD * Inline [
Column1,Column2,Column3
ABC,A1,B1
,A2,B2
,A3,B3
XYZ,X1,Y1
,X2,Y2
];