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
Found the answer ....
LOAD @1 as Country,
@2 as State,
@3 as Region
(ooxml, no labels, table is SystemFile, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
Retrieving data ...