topic Re: header (field name) in QlikView

header (field name)

Anonymous — Mon, 06 Jan 2014 10:03:40 GMT

how can i load just the header of the table ? just the fields names?

thanks a lot

Re: header (field name)

Peter_Cammaert — Mon, 06 Jan 2014 10:07:14 GMT

Create a LOAD statement without embedded header and add the prefix FIRST 1

Peter

Re: header (field name)

jagan — Mon, 06 Jan 2014 10:07:24 GMT

Hi,

Try like this

LOAD

FROM FileName

WHERE 1=2;

Regards,

Jagan.

Re: header (field name)

Anonymous — Mon, 06 Jan 2014 10:14:30 GMT

could u give an example?

Re: header (field name)

Anonymous — Mon, 06 Jan 2014 10:14:56 GMT

on a big table this will take a long time

Re: header (field name)

senpradip007 — Mon, 06 Jan 2014 10:21:33 GMT

Try this:

LOAD A,

FROM

C:\Data\TestData.xlsx

(ooxml, no labels, table is Sheet1)

Where RowNo() < 1

Hope it will help you.

Re: header (field name)

jagan — Mon, 06 Jan 2014 10:26:08 GMT

Hi,

Then try like this

LOAD

WHERE 1= 2;

FIRST 1 LOAD *

FROM DataSource;

Regards,

Jagan.

Re: header (field name)

Anonymous — Mon, 06 Jan 2014 11:06:44 GMT

yeah i thought about that

FIRST 1 LOAD *

FROM DataSource

and then

LOAD

WHERE 1= 2;

but it is still a big table and the first part takes a long time

Re: header (field name)

tresB — Mon, 06 Jan 2014 11:19:55 GMT

Try like:

TempTable:

First 1 Load * <Datasource>; // it will read single (the first one) record and should not take much time;

Final:

Load

'1' as Jnk

Resident TempTable Where 1=2;

Drop Table TempTable;

Drop Field Jnk;