Append data when columns missing from input data

user03144

Hello. 

 

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?

Property_Ninja

Hello,

 

What does your source query look like in workbench? You may have to actually name the fields in the source query.

For example ... 

 

select null as id
,null as timestamp
,make
,model
,year
from fake_table

Hope this helps,

 

Brian

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.