Specify multiple appending spreadsheets, with their own merge settings #3
Description
Is your feature request related to a problem? Please describe.
- 2 appending spreadsheets exist
- Both share the same key column name, and roughly the same row values (some keys in sheet B do not exist in sheet A)
- Sheet A needs all of the columns that exist in the original sheet to be merged
- Sheet B needs only needs certain columns merged
- While this would currently be supported by removing/adding those columns to the original sheet, there are also duplicate columns that exist in sheet A
- Sheet B's version of the sheet A columns need to be ignored during the merge
- Need a way to merge multiple sheets simultaneously, while maintaining separate merge settings for each "type" of sheet
- Either sheet A or B needs to be merged, but don't necessarily need them at the same time every time
- Sheet A and B would need to have separate timestamps to indicate when they were merged
Describe the solution you'd like
- For each sheet type, create list of particular "sheet types"
- For each type, user can specify different merge rules that currently exist
- Add new rule for ignoring certain columns during the merge
- if column names do not exist in the actual appending sheet, then a failure needs to occur
- then different appending sheet can be optionally provided for each set of rules
- Need to fail if:
- none of the sheet types are provided a sheet name
- Provided sheet files for each type have overlapping columns (merge would not know which columns to pick)
- Add ability to name each group
- Would need a way to copy existing config to support these "types" (which would have their own settings)
- Still other "global" inputs the same:
- Original sheet (or copy) name