How can I use action "Excel: Remove duplicate rows" by input multiple columns?
Hello, dear team:
I want to use the action "Excel: Remove duplicate rows" to remove duplicate rows via all columns of my excel file, which is from column A to V.
What is correct way to define the columns in the action?
It is not clearly clarified via support page https://help.catalytic.com/docs/excel-remove-duplicate-rows/
Below is my input of the action which comes cross a error.
Best Answer
-
@BIN_127767 The Column setting applies to one single column. Removing duplicates, for many columns at once, is a product idea available for upvoting here:
Excel: Remove Duplicates - Multiple Columns
https://community.pushbot.com/discussion/553Today, you would need one action for every column. I recommend storing these actions within a helper workflow by using the action named Start a Workflow with a Workflow.
One note of caution based on my testing of Excel: Remove duplicate rows:
If the specified column in the input file is empty, the other columns in the output file will also be empty. So you will always want to have data in the column where you remove duplicates.Start a Workflow with a Workflow
https://help.catalytic.com/docs/start-a-pushbot-with-a-pushbot/#access-or-review-your-helper-workflowsIf you encounter issues with this building suggestion, please reach out to me at help@catalytic.com.
Thank you!
5