If Column Title Similar, Combine Two Columns into One

[yoyoumysin]

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.

Invoice	Paid on 01-15-2024	Right_Paid on 01-15-2024
Store A 001	2189.97
Store B 002		476.54
Store A 003	3987.76
Store B 004		43578.00

[binuacs]

@yoyoumysin use the dynamic select tool

[Qiu]

@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

[kamal03]

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