Forum Discussion
File contains corrupted data with $_xlnm#_FilterDatabase
Hi. Consider that when you combine files there is a lot of code generated automatically. A new folder is created where the code of this combination is built. In order to work with the transformation of every file before gathering all together, you could change code there. You might need some power query skills. Check this out:
There you can find a "Transform File" with an Fx symbol. That is the function that will run for each file. Check the transformations. If there is something there you can do to prevent the "$" like make the column text, prevent convert to number or replace values. You could work in there. To make it easier to understand, you can test drive your changes with "Transform Sample File". If I'm correctly you can modify that one and nothing should change. That table is an example.
I hope that helps,
Hi. Consider that when you combine files there is a lot of code generated automatically. A new folder is created where the code of this combination is built. In order to work with the transformation of every file before gathering all together, you could change code there. You might need some power query skills. Check this out:
There you can find a "Transform File" with an Fx symbol. That is the function that will run for each file. Check the transformations. If there is something there you can do to prevent the "$" like make the column text, prevent convert to number or replace values. You could work in there. To make it easier to understand, you can test drive your changes with "Transform Sample File". If I'm correctly you can modify that one and nothing should change. That table is an example.
I hope that helps,