Choose second Row as HeadRow

[Anonymous]

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

[marcus_sommer · Accepted solution]

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