topic QVD Embedded Labels in QlikView

QVD Embedded Labels

Wed, 01 Jul 2015 13:20:12 GMT

Hi,

I have a series of QVD's within which row 1 contains the headers for the file.

Is there a way to replace the existing qvd headers with the data for each field in row 1? Basically I want to apply the "embedded labels" option which is available when uploading an excel file.

Thanks,

John

Re: QVD Embedded Labels

marcus_sommer — Wed, 01 Jul 2015 13:30:39 GMT

It's not quite clear what do you want to do - but I think you will need to adjust the table before they will be stored as qvd - fieldnames are esential even if they are only column-no like @1, @2 ...

- Marcus

Re: QVD Embedded Labels

Wed, 01 Jul 2015 13:33:54 GMT

Hi,

Try this:

open the qvd from table files, click on next -> next ->in file wizard.

then you will find labels in the next window. select embedded labels and then do the actions you want and click finish.

HIC

Re: QVD Embedded Labels

Wed, 01 Jul 2015 13:46:06 GMT

Hi Marcus,

Hopefully the below will clear it up. I need to replace the row in orange with the row in green and use this row as the new fieldnames.

Re: QVD Embedded Labels

Wed, 01 Jul 2015 13:47:45 GMT

Hi Prrajendran,

I tried this option but it doesn't seem to have any impact on a qvd load, the labels remain the same as they are without selecting embedded labels.

Has this worked for you?

Re: QVD Embedded Labels

Wed, 01 Jul 2015 13:58:32 GMT

if you want to rename the labels,

then...after selecting Embedded labels. double click on the label and rename in the wizard

Re: QVD Embedded Labels

Wed, 01 Jul 2015 14:06:53 GMT

or you can do this.

open qvd, click next-> enable tranformation step -> select the row 1 -> click delete marked -> next ->

embedded labels -> double click on column name, then rename field1 as Name, field2 as.......

then click finish

Re: QVD Embedded Labels

Wed, 01 Jul 2015 14:14:13 GMT

Thanks Prrajendran, this needs to be a scripted solution I'm afraid. The above was just an example, the actual issue applies to thousands of files with around 100 fields in each file.

Re: QVD Embedded Labels

marcus_sommer — Wed, 01 Jul 2015 14:45:25 GMT

Have a look on this example - it's not very elegant but it worked. Origin and table1 are only kept to show the interim stages.

- Marcus

Re: QVD Embedded Labels

Wed, 01 Jul 2015 16:26:53 GMT

Thanks Marcus, the combination of crosstable and mapping loads along with only loading row 1 worked perfectly!