Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add column to a table?

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

2 Replies
maverjannet
Specialist
Specialist

used to concatenate fields &


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

Not applicable
Author

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.

View solution in original post