How to load three tables

[#1]

Hi all,

        I have three table.These table are containing various values.then how to load in three tables to one table and how to join these tables.

[#2]

Can u provide Example Data  so we can understand clearly

[luis_pimentel]

If you search in this community you will find hundreds of threats about loading and joining tables.

[salto]

Hi Mani,

do the tables have the same fields? If so, Qlik will concatenate them automatically.

If not you will need to concatenate them explicitly with the concatenate command.

Would you please let us know the fields in the tables  so we can help you more?

Cheers.

[MayilVahanan]

Hi

If there is many common fields in each table then create "Key" field by using autonumber function and join with another table.

If there is a common field, then use that field for join.

[#6]

You can use following ways:

1) You can use associative join , which qlikview automatically creates. This done by keeping same column name in tables to be joined. Eg:

Table1

Name,

Account

Table2

FirstName,

Phone

Then to join Table1 and Table2, just rename the Table2 FirstName column to Name like

Table2

FirstName as Name,

Phone

2) Use JOIN keyword.

3) You can concatenate the 3 tables into one.

Thanks,

Angad

[#7]

Hi Salto,

           Please find the sample image,These tables are should not have unique value then how to load these tables to one table, and how to mention it which is matching,Not matching and Rejected values.

[salto]

Status	ID
Matching	GK53391
Matching	GK53392
Matching	GP79790
Matching	GS53737
Not_Matching	GI84088
Not_Matching	...
Not_Matching	GW16031
Rejected	GE...
Rejected	GV07018

Is this what you need?

[#9]

Hi Mani,

You must think that the tables in qlikview will be joined by all fields that the names be the same between the tables. So using the sentence JOIN above each load of second and third table, looking the fields with the same name are only the fields you like to join.

As Luis says you can find a lot of information in community to pursue the subject.

I hope to be helpful to you.

Regards.

[#10]

Hi Salto,

            Yes i want this,, Please give solution