Putting an Input into a Blank Template

Question

Hi!

I have a data set that I am working with and need to align the data to fields in a template. The field names and field location do not align. I have previously been copying and pasting the data from the output file into the corresponding fields of the template in excel. The template is blank (only includes field names), I simply just need to get my data into the format of the template so that I can upload it into a visualization software.

Thanks in advance for any guidance!

davidskaife · Answer

Hi @kaylagross12

On the Output tool you have the option to append to existing sheet, and can define how it appends (by Field Name or Custom):

So if your field names are identical it appends straight away, if they are not you can change option 4 to custom mapping and define how they map.