Hello,
I have to filter records in two columns in my dataset. Once I did that, I have to move the filtered records to a new column. I am unable to do so, please help!
Example - Column one (Address) [ Filter words PO BOX]
Column two (Address2) [ Filter words PO BOX]
Then After Getting the results in output , moving the filtered PO BOX records to a new column (Address 3) and deleting the records from Column one and two.
Thanks!
Solved! Go to Solution.
Hi @pardesi_geet , is it possible for you to share the sample workflow or dataset for better clarity?
Thanks.
@pardesi_geet , you can add a formula tool on both the filters with Address and Address 2 and name the field as PO BOX Address and in the formula tool use field [Address] and [Address 2] it will create a duplicate field, then use select tool too remove the unwanted fields. Please refer to the screenshot for clarity.