Combinging three tables in the script

[#1]

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,

[SergeyMak]

Concatenate?

Join?

[senpradip007]

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);

[ashfaq_haseeb]

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

[its_anandrjs]

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;

[#6]

I did, but I want to make a final single table.

[SergeyMak]

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.

[#8]

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

[ashfaq_haseeb]

Hi

Did you try my solution?

Regards

ASHFAQ