Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Guru's,
i have requirement, where i have to import data from excel as attached.
Data is in format of sheet 1 and we need the data to be in format of sheet 2.
request to let me know how to load this data, thanks in advance
Dear Friends,
Found the answer ....
Table:
LOAD @1 as Country,
@2 as State,
@3 as Region
FROM
Data.xlsx
(ooxml, no labels, table is SystemFile, filters(
Transpose(),
Replace(1, top, StrCnd(null)),
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));
Dear Friends,
Found the answer ....
Table:
LOAD @1 as Country,
@2 as State,
@3 as Region
FROM
Data.xlsx
(ooxml, no labels, table is SystemFile, filters(
Transpose(),
Replace(1, top, StrCnd(null)),
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));