Joining two tables

[#1]

Hello

I have two tables with the same fieldS but different data. So how can I join them.

I know the question is very simple but I am very new to Qlikview and I am unable to figure how to do this!

TIA

Arjun Jain

[robert_mika]

Is there one common field name?

If yes qlikview join them automaticly.

Otherwise see this:

www.qlikviewaddict.com/2012/03/explaining-joins.html

[prma7799]

Hi Arjun,

Try like this

Table1:

LOAD * Inline
[
Min_Marks, Max_Marks, Result
10, 30, Fail
35, 40, Pass
45,60, Average
75,80, Honour
]

;
   

Concatenate

LOAD * Inline
[
Min_Marks, Max_Marks, Result
10, 70, Pass
10, 20, Fail  
];

[PrashantSangle]

Hi,

If you have two tables with all same fields then it will automatically concat with each other.

Regards

[#5]

No that is not what happens!

I am just wondering if that happened what would be the name of the concatenated table, table1 or table2?

[PrashantSangle]

If you are taking above example then it will be

Table1.

If this is not happening then you have some extra fields also.

If possible post your script.

Regards

[jagan]

Hi Arjun,

Assume that you have Actual and Budget data then you can use Concatenate() in Qlikview and merge two tables into one like below

Data:

LOAD

*,

'Actual' AS DataTypeFlag

FROM ActualTable;

Concatenate(Data)

LOAD

*,

'Budget' AS DataTypeFlag

FROM BudgetTable;

By using the DataTypeFlag we can easily identify the source of the row.

Hope it helps you.

Regards,

Jagan.