topic Re: Joining two tables in QlikView

Joining two tables

Thu, 12 Feb 2015 07:04:45 GMT

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

Re: Joining two tables

robert_mika — Thu, 12 Feb 2015 07:11:37 GMT

Is there one common field name?

If yes qlikview join them automaticly.

Otherwise see this:

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

Re: Joining two tables

prma7799 — Thu, 12 Feb 2015 07:11:56 GMT

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
];

Re: Joining two tables

PrashantSangle — Thu, 12 Feb 2015 07:14:11 GMT

Hi,

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

Regards

Re: Joining two tables

Thu, 12 Feb 2015 07:25:04 GMT

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?

Re: Joining two tables

PrashantSangle — Thu, 12 Feb 2015 07:28:12 GMT

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

Re: Joining two tables

jagan — Thu, 12 Feb 2015 07:43:03 GMT

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.