topic Re: short question start row = row 3 in QlikView

short question start row = row 3

Thu, 25 Dec 2014 22:10:08 GMT

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

Re: short question start row = row 3

MarcoWedel — Thu, 25 Dec 2014 23:44:26 GMT

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;

Re: short question start row = row 3

jagan — Fri, 26 Dec 2014 02:20:34 GMT

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.

Re: short question start row = row 3

MarcoWedel — Fri, 26 Dec 2014 08:41:30 GMT

To clarify please post sample data

Re: short question start row = row 3

Fri, 26 Dec 2014 12:35:17 GMT

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

BR T

Re: short question start row = row 3

MarcoWedel — Fri, 26 Dec 2014 13:25:03 GMT

You're welcome.

Please close your thread if there are no further questions.

Regards

Marco

Re: short question start row = row 3

MarcoWedel — Mon, 29 Dec 2014 19:33:48 GMT

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