Forum Discussion
Combining multiple columns together using parameters derived from an aggregated table
Do your incoming tables have the same structure? Meaning are the columns in the same order even if they are spelled differently?
It is only one table with a fluctuating/ever-expanding number of columns. Each time someone adds a new form in the GUI, new columns can be added to the output structure. Depending on the labels of each column (by default the labels get used as the field names) new columns may get added to the output the next time I do an export. This is why I run the steps to try to determine which columns to combine into one column output because no matter if the form creator types "company", "Company", "Company Name", "Organization", etc into the form creation, it all means the same thing and for any given row (form submission) there will only be one value total across all those columns for that row.