Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have three tables in the script and wanted combine together, I can do using store command into QVD's, is there any possibility to do in the same script at the end of the script.
Thanks,
Concatenate?
Join?
You can use Concatenate() if the field names are different otherwise it would concatenate automatically.
Ex:
Tab:
Load
A,
B
From <Source1>;
Concatenate(Tab)
Load
A,
C
From <Source2>;
Concatenate(Tab)
Load
C,
D
From <Source3>;
Store Tab Into Tab.qvd(qvd);
Hi try below
Main_Table:
load * from table1
concatenate
load * from table2
concatenate
load * from table3
store Main_Table into Table.qvd.
hope it helped.
Regards
ASHFAQ
Yes at the end of the table loads put STORE COMMENDS with the table name, If there is relation between this tables then use Joins or Concatenate
T1:
Load * From Loaction;
//Join or Concatenate Here
T2:
Load * From Location;
STORE T1 into T1.qvd;
I did, but I want to make a final single table.
Can you describe these tables or even share the app.
Because it's not clear for me what you have now and what you'd like to achieve.
Hi Madu
Hope you are doing well.
There are two things you can do either Join OR concatenate.
1. Join will help you get the data from different tables basis the relationship they hold.
2. Concatenate will just append the data of one table to another.
Now basis your requirement you can use any of the functionality.
Regards
Rishi Beri
Hi
Did you try my solution?
Regards
ASHFAQ