How to append or update by multiple "match on column" not only single column

Describe the problem/error/question

what if my unique column is combination of multiple column? the columns are brand, store, and channel. How node append or update spreadsheet can reads multiple column? because now there is only one “match on” available. For now i only match the column by store where its not unique, i have id column but it may also not be unique. Thanks

Please share your workflow

Share the output returned by the last node

Hi @Faizal_Abdul_Hakim_I :wave:

There isn’t a way to match on multiple columns right now, so I’ll be moving to this to the feature request section of our forums.

When trying to test a workaround for you, I was mainly focusing on the concatenation formula, such as adding a new column with something like =CONCATENATE(A2, " ", B2) to take two columns and add a space between them. Unfortunately unless you’re very comfortable with Regex, this method will not work for you. You may need to look into using a database instead of Google sheets to be able to make more complex queries if you need this type of matching :see_no_evil:

1 Like

Okey thanks for your answer @EmeraldHerald , i think for now i will use the ID column to match on and hope the user doesn’t wrong input the ID.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.