How to extract the rows based on a specific value of a column?

How can I extract all the rows based on a specific value of a column, send that to one table, while another value will be sent to another table?
For example:
I have a country column, in that country column, there’s US and CA.
If US then all rows and data that has US in the country column would populate in one table.
If CA then all rows and data that has CA in the country column would populate in another table.
Ultimately these separate tables will be two files that will be exported.

1 Like

Hi @Dang_Thai!

I would use two separate Row Filter steps, one for US and one for CA, as shown below:

On your Canvas:

In the Row Filter steps:

You can build your flow off of these two branches to export independently to unique destinations.

If you want the remainder of the flow to be the same for each branch, build one flow first, then select all of the steps. Copy the steps with the keyboard shortcut (Command+C or Ctrl+C), and then Paste with the keyboard shortcut (Command+V or Ctrl+V). Finally, just connect your 2nd branch to the steps!

Hope that helps!

3 Likes