Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is there one common field name?
If yes qlikview join them automaticly.
Otherwise see this:
www.qlikviewaddict.com/2012/03/explaining-joins.html
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
];
Hi,
If you have two tables with all same fields then it will automatically concat with each other.
Regards
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?
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
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.