Moving Filtered Entries from one Column to a new column

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!

Accepted answers

grazitti_sapna

@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.

All comments

grazitti_sapna

Hi @pardesi_geet , is it possible for you to share the sample workflow or dataset for better clarity?

Thanks.

pardesi_geet

Yes sure, so I am trying to copy and move PO BOX and its number from Address & Address 2 column to a new column ( which I haven't created yet) called PO BOX Address.

Screenshot 2020-06-22 at 9.13.00 AM.png

grazitti_sapna

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703