Append data when columns missing from input data
I have a master dataset in domo which was originally extracted from a legacy system, and has 'timestamp' and 'id' columns which were specific to the legacy data set. New data is identical but with the exception of the fact that it doesn't include those columns. It seems if I try to append the data to the master data set, it just removes those columns entirely from the main data, which I do not want. I can see that I could create a new dataset from the new data, and then merge them in domo, but it looks like that will duplicate the number of rows that I have in the system - my master dataset is already 8m rows so I don't want to duplicate this for allowance reasons.
Is there anything I can do short of having to manually add null 'timestamp' and 'id' columns in new data before it is appended?