Hi,
I'm receiving this error with my query, and I can't understand why. I've checked some other topics for this issue, but haven't found a solution. In order to isolate the problem, I went from the end of my query and deleted every step until I found where the error was occuring, and it seems to be happening when I merge two queries together. This is where the problem happens:
#"Merged Queries2" = Table.NestedJoin(#"Added Conditional Column3", {"lookup for case name"}, #"raw data", {"Contract ID"}, "raw data", JoinKind.LeftOuter),
#"Expanded raw data" = Table.ExpandTableColumn(#"Merged Queries2", "raw data", {"CBT", "CT", "Case"}, {"raw data.CBT", "raw data.CT", "raw data.Case"})
If I delete the Table.ExpandTableColumn step, the error goes away. I've checked the columns in my raw data file, and there are no nulls there. I can't figure out what null it's trying to convert. Any help?
thanks,
