Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
All my sheets that are beeing imported to qlik sense have start row 3.
That means that on the first and second row there are some information that I do not want to include in my application.
I have tried to use "header is 2 lines" but I cannot get this to work - do I use the wrong syntax? Or use it in a wrong way?
Any help would be appriciated.
BR T
LOAD
@1 as Bokföringsdatum,
@2 as Transaktionsdatum,
@3 as Enskild_Transaktion,
@4 as Belopp,
@5 as Behållning,
ApplyMap('mapping_transaktionstyp',@3,'Ej Mappat') as Transaktionstyp,
ApplyMap('mapping_transaktion',@3,'Ej Träff') as Transaktion
FROM [lib://Lönekonto TPL/Kontoutdrag_nov_2014.xls]
(html, codepage is 1252, no labels, table is @1, header is 2 lines);
Thank you Marco Wendel and Jagan for all your help. It works with RecNo >= 3;
BR T
You could also try to add a where clause instead of the header line:
LOAD
@1 as Bokföringsdatum,
@2 as Transaktionsdatum,
@3 as Enskild_Transaktion,
@4 as Belopp,
@5 as Behållning,
ApplyMap('mapping_transaktionstyp',@3,'Ej Mappat') as Transaktionstyp,
ApplyMap('mapping_transaktion',@3,'Ej Träff') as Transaktion
FROM [lib://Lönekonto TPL/Kontoutdrag_nov_2014.xls]
(html, codepage is 1252, no labels, table is @1)
Where RecNo()>=3;
Hi,
If you have header in first row then header is 2 lines won't work if header is in 3rd row then this works, then you need to use
LOAD
*
FROM Excelfile
WHERE RecNo >= 3;
Regards,
Jagan.
To clarify please post sample data
Thank you Marco Wendel and Jagan for all your help. It works with RecNo >= 3;
BR T
You're welcome.
Please close your thread if there are no further questions.
Regards
Marco
Thanks for closing your Thread.
If you mark an answer correct, that actually answered your question, this would help readers of this forum to find what they are looking for.
regards
Marco