Forum Discussion
Solved
merge 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...
ahuhn 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...
Love that idea!
Unfortunately, I get the following error:
Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=Type
ahuhn Before pivoting, please Change the DataType of "StatusLevel" to "WholeNumber" and give a try...