Forum Discussion
Merge Issue: Expression.Error: We cannot convert the value "[Binary]" to type Binary.
StefanoGrimaldi Thank you for your answer!
I am aware of the combine files functions and thought of using it for combining the Excel files. But I don't want to combine all of the files and filter based on the metadata. For that I need to merge the SharePoint file list with another table. And that destroys the "Content" column (as described above).Any ideas how to fix this? 🙂
Resident Rockstaryou cant combine directly the binary type files in 1, practically thats no data thats a file type to get data from, here you can use the combine files functions, it will get the files from a specific folder (you can filter the files you dont want to be merge in this process in the final query) this will allow to use a file as example to do the tranformation and run a function that will apply that tranformation to all files and merge them in 1.
keep in mind this its a premiun function for dataflow (can be done with normal licences on desktop) but for dataflows you need prim cap or ppu licence