topic Loading all fields and changing one in QlikView

Loading all fields and changing one

Tue, 17 Jan 2012 11:02:19 GMT

Hi!

I have the following issue. I need to load all fields from a QVD file where I need to change one of them. To keep the script adaptive to the adding and removing of fields I would like to use the * instead of the field names. After I have changed one of the fields the table needs to be concatenated to another table. Any ideas of doing this without to many temporary tables? Ideally the script would look something like this:

Concatenate Load

* (without field x),

field x

From

temp.QVD;

Thanks for any help!

Loading all fields and changing one

vijay_iitkgp — Tue, 17 Jan 2012 11:09:19 GMT

Hi,

You can write

Load

Field x as Field y

from temp.qvd;

Drop Field x

rename field Field y to Field x;

Hope this will help

Re: Loading all fields and changing one

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 11:15:43 GMT

Good one Vijay,

Even faster if you do the RENAME only one:

Data:
LOAD * // x field is here as "original"
FROM File.qvd (qvd);
RENAME FIELD original TO x;

Hope that helps.

Miguel

Loading all fields and changing one

Tue, 17 Jan 2012 11:18:33 GMT

Thanks for your answer. This still requires me to do a concatenate and drop table statement. Is there an easier way to concatenate the table after I have renamed the field?

Loading all fields and changing one

Tue, 17 Jan 2012 11:19:22 GMT

Thanks for your answer. I need to manipulate the original field so I will need the step in between.

Loading all fields and changing one

vijay_iitkgp — Tue, 17 Jan 2012 11:31:32 GMT

I dont know if I understand correctly

but U can do:

Load

Field x as Field y

from temp.qvd;

Drop Field x;

rename field Field y to Field x;

Concatenate

Load

from temp2.qvd;