how to auto merge tables?

[#1]

i need to know how we can merge two or more tables automatically ??

[ThornOfCrowns]

Look at the Concatenate functionality.

[arsal_90]

Please find the attached file for your understanding.

[Colin-Albert]

If the tables have exactly the same column names, then QlikView will concatenate the data to a single table automatically.

Search for Concatenate and Noconcatenate.

[its_anandrjs]

Hi,

If the column name or field name of the 2 tables are same then qlikview automatically concate 2 or more tables and make single table. You are able to merge two or more tables but it requires table field name should exactly the same then your are able to concate them.

Eg:-

Tab1:

Load

Field1,

Field2,

Field3

From yourlocation;

Concatenate(Tab1)

Tab2:

Load

Field1,

Field2,

Field3

From yourlocation;

will give you single table.

if field name not same so make it same by renaming it

Tab1:

Load

Field1,

Field2,

Field3

From yourlocation;

Concatenate(Tab1)

Tab2:

Load

Field4 as Field1

Field5 as Field2

Field6 as Field3

From yourlocation;

now i update the syntax script please check now.

Hope this helps

Thanks & Regards

[#6]

if they have Same Column Name then they will merge automatically and if not if you want they don't have all Column Name  same then u can use forced Concatenate

[amit_saini]

Hi Gatik,

You should you here Concatenate and No Concatenate function , if you are having same fields in two or more different tables.

Thanks,

AS

[#8]

If we are trying to do this way then we are getting something like this.

F3	F4	Location	Product1	Product2	Product3
B	C		A
B	C			A
B	C				A
20	30	AP	10
21	31	MP	11
22	32	UP	12
23	33	Kerala	13
24	34	Delhi	14
121	131	AP		100
122	132	MP		101
123	133	UP		102
124	134	Kerala		103
125	135	Delhi		104
300	400	AP			200
301	401	MP			201
302	402	UP			202
303	403	Kerala			203
304	404	Delhi			204