Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I've difficult task, I need to load data from the files where data located not normally. Data located in blocks with three lines. please see example below:
Sales Cost | |
Upload Cost | |
Sellthru Cost |
$1,969 | |
$2,363 | |
83.3% | |
$4,348 | |
$5,591 | |
77.8% | |
$4,486 | |
$6,334 | |
70.8% | |
What should I use in this case I've never loaded data from such files.
Hi,
another solution could be:
tabTemp:
LOAD @1 FROM [https://community.qlik.com/thread/169008] (html, codepage is 1252, no labels, table is @3);
mapColNam:
Mapping
LOAD RecNo(), @1
Resident tabTemp
Where RecNo()<=3;
tabColVal:
Generic
LOAD Div(RecNo()-1,3) as ID,
ApplyMap('mapColNam',Mod(RecNo()-1,3)+1),
@1
Resident tabTemp
Where RecNo()>3;
DROP Table tabTemp;
hope this helps
regards
Marco