merge queries - expression error

[Anonymous]

HI All, 

I've just trying to merge 2 queries. One is from sharepoint source the other is just a CSV. 

Im getting:

Expression.Error: We cannot convert the value "[Record]" to type List.
Details:
Value=[Record]
Type=[Type]

The colum im using to merge are unique codes in a one to many relationship. 

I'm not really sure where to look as this worked previously when I did CSV to CSV. 

Thanks

[edhans]

You are going to need to share screenshots or data for us to help. What has likely happened is the field you are merging on in SharePoint is not a text or numeric field, but a multi-row field. A multi-row field acts as a single value when there is only one row, but if the user adds a 2nd row by pressing ENTER in the dialog box, SP turns that value into list and that will merge. 

But without screenshots it is hard to say. This is a data issue though, not a bug, and not likely anything you are doing wrong in the merge, it is just unexpected data structures messing it up.

[Anonymous · Accepted solution]

Yes, i got there eventually. I expanded all the multi-row fields but it still wouldnt merge. I then tried merge to new and this worked perfectly. So it's all sorted now.