Forum Discussion
Expanding Table after a merge
Hi, I have a little problem expanding table after a merge
So here have three visualizations
- All
- col
- Merge1
As you can see two record records match on the highlighted columns, but no rows in the Merge1 table.
This is how I got to this result.
= Table.NestedJoin(All,{"cec_upn", "dx_dte", "Index"},Col,{"cec_upn", "dx_dte", "Index"},"Col",JoinKind.Inner)
All good sofar.
I then did
= Table.ExpandTableColumn(Source, "Col", {"cec_upn", "colorectal_case_cde", "dx_dte", "icd3_cde", "Index"}, {"Col.cec_upn", "Col.colorectal_case_cde", "Col.dx_dte", "Col.icd3_cde", "Col.Index"})
v
Everything was done thru the UI.
Can you explain why I get an empty table.
Thanks Fred
Hi Fnoorda,
I have test your issue, and it works after I merged two tables:
One possible condition in your case is that the data type of columns in table All doesn’t match the data type of columns in table Col. Please check if data types of columns are same in two tables.
Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0
Best Regards,
Jimmy Tao
2 Replies
v-yuta-msftCommunity Support
Hi Fnoorda,
I have test your issue, and it works after I merged two tables:
One possible condition in your case is that the data type of columns in table All doesn’t match the data type of columns in table Col. Please check if data types of columns are same in two tables.
Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0
Best Regards,
Jimmy Tao
Thanks Jimmy that does solve the problem. Thanks for your help. Powerbi does seem to change the data type sometimes from whatever it is to this "any type" I asume that equtes to variant.
Thanks again.
