topic Add column while loading in QlikView

Add column while loading

Thu, 15 Apr 2010 11:59:23 GMT

Hi all,

i'm in front of a little issue that i do not manage to solve.

I have an Access table that i can't modificate that i load trough script; so far no problem.

My question is: can i write something in the script of this table that would enable me to add a column directly from the script and enable me to avoid modificate the Access table?

Add column while loading

vidyut — Thu, 15 Apr 2010 12:10:57 GMT

Hi,

Yes, It should be possible. Here is an example, where you get Column 1&2 from Access and Column 3&4 are added while loading the data:

Load Column1,Column2, 'Hyper' as Column3,'Hyper' as Column4

From YourAccessDBTable;

Add column while loading

Thu, 15 Apr 2010 15:28:38 GMT

Thanks,

but i think that this would just change the name of the column; altought, i'd like to fill the whole column wit "Hyper"

Add column while loading

johnw — Fri, 16 Apr 2010 01:17:44 GMT

What he said will fill Column3 and Column4 with the value 'Hyper' in every row.

Add column while loading

Fri, 16 Apr 2010 09:35:05 GMT

Works perfectly thx