Forum Discussion

Sarcasticus's avatar
Sarcasticus
Frequent Visitor
3 years ago

Dynamically merge two tables repeatedly

Using PowerBI Datamarts to build a diet Data Warehouse for a third-party solution. The solution will export Excel files to a data lake via SFTP that are essentially one per table. The way this third ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Sarcasticus ,

According to your description, I create a sample and please see if this can help you:

1.In Claim Table, select CustomCode1ID, CustomCode2ID, CustomCode3ID at the same time then click Unpivot Columns.

2.Select Claim Table, then click Merge Queries as New.

3.In the merged new column, expand Description and CodeTypeID columns.

4.Select the new table, click Merge Queries

5.Expand the Description column.

Get the result:

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sarcasticus's avatar
Sarcasticus
Frequent Visitor
3 years ago

Thank you.

 

Just as an FYI, from there, I pivoted on the CodeTypeTable.Description with the value field being the CodeType.Description, giving me what I needed.