Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Add column while loading

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?

More in details:

I load a table, but i would like to add a columns with the same text in each cells. text would be for instance: "Hyper"

i hope i'm clear.

i don't know if that's possible but i think it is, that's why i ask [^o)]

Thanks all

1 Solution

Accepted Solutions
Not applicable

Add column while loading

Works perfectly thx

View solution in original post

4 Replies
Partner
Partner

Add column while loading

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;

Not applicable

Add column while loading

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"

Highlighted
MVP
MVP

Add column while loading

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

Not applicable

Add column while loading

Works perfectly thx

View solution in original post