Concatenate issue

[surajap123]

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!

[annafuksa1]

you should to use left join

look at the app t have attach

Anna

[marcus_sommer · Accepted solution]

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

[surajap123]

Thank you so much. I like your second approach