Choose second Row as HeadRow

Anonymous — Tue, 23 Aug 2016 13:16:40 GMT

Hi,

how to make the second row as HeadRow. I have a stored .qvd and when I load this QVD a get a table like this.

TTU, Num

ID, Number

1, 123

Is it possible to "clear" the first row and make the second row on top?

Finally the table must look like this:

ID, Number

1, 123

Now here you can see my loading process:

for each File in FileList(vFolder& '\*.qvd')

Concatenate(Result)

Load *

From [$(File)] (qvd);

next File

What I have to change that this expression gives back the "Finally" table?

Thank you

Re: Choose second Row as HeadRow

marcus_sommer — Tue, 23 Aug 2016 15:57:50 GMT

I suggest to adjust this within a previous layer in which those qvd's was generated. For example you have within the table-wizard an extra option by text- and excel-files to choose which record should be taken as fieldname.

- Marcus

topic Re: Choose second Row as HeadRow in QlikView

Choose second Row as HeadRow

Re: Choose second Row as HeadRow