Both source Excel and TWBX are attached.
In Excel I've got two sheets that I'd like to join. "Location code" column is problematic - is it possible to join if one sheet contains some elements (codes) that the second sheet does not?
Someone might report quantity in first sheet on certain location, but the amount in second sheet does not have to be reported on that location. And vice-versa - there might be an amount on certain location (second sheet), but no quantity (first sheet). Would this be the cause of problem?
But in above case I was hoping that I will be able to create a table with all possible location codes from both sheets (dimension) and show two measures in columns: quantity and amount.
Thanks for looking at this.
I believe it is the format of the columns in the excel file. One column in set to general, while other is text. Set it to the same format, and I am pretty sure it should work.
No, that is not the problem. I tired setting both as General - but no luck.