Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge. |
Visit the official Paxata Documentation portal for all of your doc needs.
Appending files (Not all columns are the same)

I have several files that I need to merge together. The file layouts are different. There are consistent columns across the files, but each file also has columns that are unique. Can Paxata help me merge these files together?
Tagged:
0
Best Answer
-
Akshay Posts: 99 admin
Files of different layouts can be appended together using Paxata. There are two important things that you should understand during this append process. The final appended dataset will contain every column present across all the data files (No duplicates). Secondly, the column values would display blank for the files that do not have that specific column.
Take the example of two datasets as shown in the image below:
Dataset 1:
Dataset 2:
The final appended dataset will look like this:
10