Forum Discussion
Combining multiple columns together using parameters derived from an aggregated table
I would brute force it. Do a simple Table.Combine that ignores the different spellings of the column, and then after the combine add a custom column that concatenates the content of all the spelling variations into a new value.
I'm sorry lbendlin, but I guess I don't understand what you're saying. I have one table with multiple sets of columns I want combined. I wouldn't be adding one custom column, I'd be adding a new column for each set of combinations I want to combine and it's that loop that I don't know how to do. Here is a screenshot of the summary results of my name-combining steps. Then I want to merge this back into what amounts in this case to 12 different columns. (The original table has something like 50 or 60 columns.)
After running a bunch of steps to identify the columns I'd like to combine.
Ultimately this is a data source where the system allows people to configure their own column names for each new form and while I wish there was some sort of enforced consistency, there is not. The good news is that when there is some sort of "Company" or "Country" field, it is 99% likely that there will only be one value. (I'll do some checks after I can get the dynamic concatenations done to verify this is true.)
Once again, I'm sorry if I missed something you're trying to get at here but I don't see how Table.Combine helps. I'm still in the situation where I need to dynamically run 12 different custom column creations and then remove the 31 columns shown here that have been combined together.
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.
