Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
what is the coulmn structure of your QvD files?
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
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
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?