Forum Discussion
ahuhn
Advocate I
Advocate Imerge filtered tables
I have one table I created two filtered tables based on this table, called T1 and T2 I need to compare specific values between T1 and T2, so I want to merge them based on common productID. ...
ahuhn Before pivoting, please Change the DataType of "StatusLevel" to "WholeNumber" and give a try...
PattemManohar
Community Champion
Community Championahuhn Please try "Pivot" option on the subset table (just with the required columns you are interested as mentioned),
Just try "Pivot" for Date field on the new table (trimmed version) in Power Query and the output will be as expected.. Not required to have two tables and then merge...
ahuhnAdvocate I
Advocate ILove that idea!
Unfortunately, I get the following error:
Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=Type
- PattemManohar
ahuhn Before pivoting, please Change the DataType of "StatusLevel" to "WholeNumber" and give a try...