topic Re: Combinging three tables in the script in QlikView

Combinging three tables in the script

Thu, 12 Jun 2014 05:19:27 GMT

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,

Re: Combinging three tables in the script

SergeyMak — Thu, 12 Jun 2014 05:22:24 GMT

Concatenate?

Join?

Re: Combinging three tables in the script

senpradip007 — Thu, 12 Jun 2014 05:24:52 GMT

You can use Concatenate() if the field names are different otherwise it would concatenate automatically.

Ex:

Tab:

Load

From <Source1>;

Concatenate(Tab)

Load

From <Source2>;

Concatenate(Tab)

Load

From <Source3>;

Store Tab Into Tab.qvd(qvd);

Re: Combinging three tables in the script

ashfaq_haseeb — Thu, 12 Jun 2014 05:25:18 GMT

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

Re: Combinging three tables in the script

its_anandrjs — Thu, 12 Jun 2014 05:25:58 GMT

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;

Re: Combinging three tables in the script

Thu, 12 Jun 2014 05:26:27 GMT

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

Re: Combinging three tables in the script

SergeyMak — Thu, 12 Jun 2014 05:29:02 GMT

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.

Re: Combinging three tables in the script

Thu, 12 Jun 2014 05:36:27 GMT

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

Re: Combinging three tables in the script

ashfaq_haseeb — Thu, 12 Jun 2014 05:38:54 GMT

Did you try my solution?

Regards

ASHFAQ