Merging two columns with only rules on what to keep

Question
1

Hi, Is it possible to merge columns 4 and 5 with it keeping what is in column 5 first and what is in column 4 if there is “no match” in column 5? I don’t want to merge all the information in both columns, only what is in column 5 then column 4 if there is no match. I hope I explain that correctly.

EDT 12 18 2021
EDT 12 18 20211183×692 59.8 KB

Thank you
Kim

2

@Kim Yes, you can do this with an If transform.

image

Ps/ Check has header on the input or use the Header transfrom to make the first row into column headers.

1 Like