If Column Title Similar, Combine Two Columns into One

Question

I have the following, not sure if achievable in Alteryx,  There are invoices that belong to two entities and in the morning I get one payment report, in the afternoon I get another, but at the end of the day, I only want one column, i.e., "Paid on 01-15-2024" in this example.

InvoicePaid on 01-15-2024Right_Paid on 01-15-2024 Store A 0012189.97 Store B 002 476.54Store A 0033987.76 Store B 004 43578.00

kamal03 · Answer

You can use this method also to get the desired output.

Combine Two Columns into One.yxzp

Qiu · Answer

@yoyoumysin 
It will really depend on what is your definition "Similar", in the sample data, if only we have the prefix "Right_" then we can do something as below

0127-yoyoumysin.yxmd

binu_acs · Answer

@yoyoumysin use the dynamic select tool

Dynamic_Select_260124.yxmd