Forum Discussion
Error when combining excel files from sharepoint
Hello Yass91 - you are getting this error because your have a step in the transform sample file query that explicitly mentioning a column named CLIENT. It must exist in the file used as the sample file but it is not present in the new file. This is why you get the error when the function is invoked. If the column is not needed, you can edit the transform sample file query to eliminate the reference to the CLIENT column. If the column is needed then you must add it to the new files.
It might be caused due to the formula you have wrtien in the custom column.
you should convert the Binary file into table using the following fomrula first then can handle some cleaning process
Excel.Workbook([Content], null, true)
Hi daircom,
I just have an Error in the column "Transform file", when the Transform file function is invoked.
Then, the error mentioned is that "The column CLIENT of the table wasn't found".
Hello Yass91 - you are getting this error because your have a step in the transform sample file query that explicitly mentioning a column named CLIENT. It must exist in the file used as the sample file but it is not present in the new file. This is why you get the error when the function is invoked. If the column is not needed, you can edit the transform sample file query to eliminate the reference to the CLIENT column. If the column is needed then you must add it to the new files.
