1 of 1 people found this helpful
An alternative approach will be to pivot Description table and then join Taxonomy to it.
Step 1: In a new workbook, add the Description Excel file and pivot the data. First select ID1, ID2 and ID3 columns. Then right click and select Pivot.
You will have this result below
Step 2: Add the Taxonomy table and do an inner join on Pivot Values to Values and using a join calculation Pivot Names+"Names" joined to Names.
Both tables are now joined without any null values.
Step 3: That's it. Just rename Pivot Field Names to ID or create a copy.
Right click on [Value] in the Measures pane and select 'Convert to Dimension'.
Hope this helps.
Thank you for taking the time to understand my poorly formulated question.
The solution I am using now is Pivoting my data source, now I have to figure out how to pivot my sql database as the two datasources are big.
You're welcome Stian.