Combine 3 tables to 1 in script

[#1]

Hi I have 3 tables.

Tab1:

F1,

F2,

F3

Tab2:

F1,

F4,

F5

Tab3:

F1,

F2,

F5.

I want final table as below

F1,

F2,

F3,

F4,

F5.

Thanks,

Lakshmi.

[martinpohl]

Here your statement:

Data:

load * from Tab1.qvd;

concatenate (Data) load * from Tab2.qvd;

concatenate (Data) load * from Tab3.qvd;

qlikView will concatenate all fields into one table called Data;

[#3]

You'll want to use Concatenate for this. When you load in tab 2 and 3, use 'Concatenate(Tab1)' and they will all be combined into the one table

hope that helps

Joe

[#4]

Hi,

It is overwriting the F1 wih Blank at some point.

If I want to append data how?

Tab1:

F1,

F2,

F3

Tab2:

F1,

F2

My Tab3 (F1, F2, F3) should contains both table recrds for F1 & F2 and for F3 only blanks where Tab2 records there.

It is like appending. How do I do that?

Thanks for reply.

[#5]

Hi,

It is overwriting the F1 wih Blank at some point.

If I want to append data how?

Tab1:

F1,

F2,

F3

Tab2:

F1,

F2

My Tab3 (F1, F2, F3) should contains both table recrds for F1 & F2 and for F3 only blanks where Tab2 records there.

It is like appending where field name is same. How do I do that?

Thanks for reply.

[ashfaq_haseeb]

Like this

Tab1:

F1,

F2,

F3

join(Tab1)

F1,

F4,

F5

join(Tab1):

F1,

F2,

F5,

Regards

ASHFAQ

[#7 · Accepted solution]

hi

try this

Tab1:

load

F1 & F2 as Key,

F1,

F2,

F3        from Tab1;

concatenate

Tab2:

F1,

F4,

F5     from Tab2;

concatenate(Tab1)

Tab3:

F1 & F2 as Key,

F1,

F2,

F5   from Tab3;

drop field key;

[deepakqlikview_123]

You can either use join or concatenate.

Thanks