I have a dataset that I have a few filters on to cut out some noise. Once I have my final sub-data set, I need to use this sub-data set to populate a standalone blank template. The sub-data set and my blank template have a lot of the same column headers but the template is blank so I can't use the join tool because there is nothing to look up off of. Any ideas?
the other approach I am thinking is by just adding in the additional columns that are on my template, but not currently on the sub-data set. If i do this, there is a column on my template, not on my sub-data set, that would need to be populated as "N/A" for each record. I can use the formula tool to create the column and change the name of it, but what syntax would I use to populate all records in this column with "N/A". If there is a way to just add the new blank column, I can then use the formula tool to replace Nulls with "N/A", I just cant figure out how to add the column and populate it in the same formula.
Please advise if you have any suggestions.
Thank you,
