Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shubham_kumar
Not applicable

I want to add one field from one table to another table fields only.

Hi,

I want to add one field only and don't want to join both the tables. Only one field want to add in anther table. How is that possible. Please advice.

Ex: I have one table1 where some fields are there and another table2 where different fields are there. but only one field from the table2 would like to add in table1 fields.

Best,

Shubham Kumar

2 Replies
vijay_iitkgp
Not applicable

I want to add one field from one table to another table fields only.

Hi Subham,

There is no option other tha join to add column .

You can do

Load

Key,

..

..

From table A

Left join

Load

Key,

Field (Column u want to add)

From Table B

Hope this will help you

Sokkorn
Not applicable

I want to add one field from one table to another table fields only.

Hi Shubham,

Try function

concatenate[ (tablename ) ] ( loadstatement | selectstatement )

Regards,

Sokkorn Cheav