Discussion Board for collaboration related to QlikView App Development.
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
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.
You can use the key that Jannet mentioned like this:
%KEY_ITEM & '_' & %KEY_CLIENT & '_' & YearMonth as NewKey
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.
View solution in original post
used to concatenate fields &
%KEY_ITEM &'_'& %KEY_CLIENT &'_'&YearMonth