topic Re: Add column to a table? in QlikView

Add column to a table?

Fri, 31 Oct 2014 14:20:15 GMT

Hi everybody. Im working editing an application, but i don´t have all the QVDs. because of that im working with a binary load.

I have to edit a link table, and i dont have the charge in the script (because of the Binary)

What i have to do is this: in the link table i have 3 fields

1)%KEY_CLIENT,

2)%KEY_ITEM

3)YearMonth

And i´d like to create a concatenated field like this %KEY_ITEM_KEY_CLIENT_YearMonth to conect with another tables i´ve created.

Anybody know who to add this to the LT?

Thank you all.

Greetings

Anonymous — Fri, 31 Oct 2014 15:29:34 GMT

used to concatenate fields &

%KEY_ITEM &'_'& %KEY_CLIENT &'_'&YearMonth

Fri, 31 Oct 2014 15:58:08 GMT

Hi,

You can use the key that Jannet mentioned like this:

LT_Edited:

Load *,

%KEY_ITEM & '_' & %KEY_CLIENT & '_' & YearMonth as NewKey

resident LT;

drop table LT;

(no need for NoConcatenate since we're not keeping same structure as the resident table, we're adding a new field in it )

Then in the table that you added, add a similar field and name it "NewKey".

Both of these tables will now be linked.