How to add columns from one qvd to another qvd?

[Anonymous]

Hi,

I have 2 Qvd, CustomerMaster and Customer_master. I need to add 5 columns from CustomerMaster to Customer_master. Can anyone give me idea how to join the columns?

[sushil353]

what is the coulmn structure of your QvD files?

[er_mohit · Accepted solution]

hiii

firstly load the qvd which have your additional 5 columns means CusterMaster;

join

load Customer_master qvd;

make sure that in between two qvd's there's one primary key if there is fieldname change but data is same then use as function or make it same fieldname

hope it helps

[kamalqlik]

Hi In case you are having th idenical structure between both the table ,ie the Coloumn name are same in both the table than use concatenation

ie

Tbale 1

Concatenation

Tbl2

.

In case the are having one fileld in common than use join

else make a composite key to join the two tables

Regards

Kamal

[Anonymous]

Re: How to add columns from one qvd to another qvd?  

I have some 200 columns in my Qvd, and that Qvd comes from joining many tables. So how can i find the primary key to add the columns?

Is that fine if we join based on any non primary key columns?