Forum Discussion
Solved
Create dimtable based on two data sources
Hi, I have 2 different data sources: 1) contains, amongst other things, employee name and turnover 2) contains employee name (but written differently)) and wage costs and a cost centre I wo...
Hi lekkerbek ,
Yes, as you said, you can append the 2 tables and then remove duplicate and remove other columns.
by this way you are creating a new table and this table will be master table, then make relationship of that 2 table with this new table.
Thanks & Regards,
Mohammed Adnan
Hi lekkerbek ,
Yes, as you said, you can append the 2 tables and then remove duplicate and remove other columns.
by this way you are creating a new table and this table will be master table, then make relationship of that 2 table with this new table.
Thanks & Regards,
Mohammed Adnan
Thanks! I got it to work.