Forum Discussion
Solved
Combine 2 files with different format
Hi! I am looking for a solution to below problem and would highly appreciate the solution to this. Is it possible to combine two excel's files with different format. For example : File...
Hi Yasser92,
Yes you can combine these files. I think you will be using Append/ Merge Queries for the same as per your need.
One take is, when you combine these data sets, you can remove the unwanted columns and combine the data sets. In case if there is a file that has an additional column, that column also will get appended while all the records who don't have that information will be null
Are you using the Combine Binaries (folder query)?
Thank you for the response.
Yes, I'm using a file as a source