Error message on merging queries: We cannot convert a value of type Record to type List..

[artpad]

Hi! I'm trying to merge two queries, one a copied query from Kusto and the other a local csv. I want to merge on a common column containing a whole number and these are the steps I followed. 

Edit Queries -> Merge Queries -> Choose the two columns containing numbers and hit Okay -> Expand new column -> select only Column 2 (containing the string corresponding with the number in Query 2)

After this, the data looks great in the query editor, but when I hit Close and Apply, I get the error message: We cannot convert a value of type Record to type List.. 

Has anyone seen this error? I know that merging will put the whole record in the new column, but when I expand that record, shouldn't that just be showing that query's column 2 as a list?

[MarcelBeug]

My suspicion is that this error must also be present somewhere in the query editor, at least I cannot think of any scenario in which this particular error would first show up when loading data.

Did you check all queries and all query steps?

Merging queries doesn't put records but tables in the new column. When this is expanded, then a code step is generated using function Table.ExpandTableColumn.

Your Column2 should be a table column (which is a list indeed, but not a separate list).

Maybe you can share your query code or some screen shots we can use for further investigation?