short question start row = row 3

[#1]

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);

[MarcoWedel]

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;

[jagan]

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.

[MarcoWedel]

To clarify please post sample data

[#5 · Accepted solution]

Thank you Marco Wendel and Jagan for all your help. It works with RecNo >= 3;

BR T

[MarcoWedel]

You're welcome.

Please close your thread if there are no further questions.

Regards

Marco

[MarcoWedel]

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