topic Re: Concatenate issue in QlikView

Concatenate issue

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

When I concatenate tables, I see that my expenses rows in straight table show region as null, even though the personID key values matches. What is the proper way to bring region values to the 2nd table, I mean the best approach to follow in my situation.

Table1:
LOAD * INLINE [
Region, Sales, PersonID
US, 100, 1
UK, 200, 2
IND, 300, 3
];

Concatenate(Table1)
LOAD * INLINE [
PersonID, Expenses
1, 10
2, 20
3, 30
];

Please note that I don't want to do join.

Thanks!

Re: Concatenate issue

annafuksa1 — Mon, 16 Jan 2017 14:36:50 GMT

you should to use left join

look at the app t have attach

Anna

Re: Concatenate issue

marcus_sommer — Mon, 16 Jan 2017 14:37:30 GMT

You could consider to use mapping instead of joining: Don't join - use Applymap instead. Another way would be to include Region to your concatenate-load or to remove from your Table1 and keep Region as an associated dimension-table to Table1 by connecting them over PersonID.

- Marcus

Re: Concatenate issue

surajap123 — Mon, 16 Jan 2017 14:48:44 GMT

Thank you so much. I like your second approach