Employee Name Searching

[SH_94]

Dear Community,

I would like to ask if we can match the two data below into one data:

May i know if this is possible done in the alteryx?

[SH_94]

Dear @atcodedog05 ,

Thanks for the explanation. Currently i have the data as below:

I plan to make the formula whereby if the Employee Name 2 column is empty , take the Employee Name data. If there is data in the Employee name 2, take the data inside it.

Do you know how to build on this as i kind of forget the formula.

Thank you.

[atcodedog05]

Hi @SH_94 ,

Formula like below should work.

IIF(IsEmpty([Employee Name 2]), [Employee Name], [Employee Name 2])

Hope this helps : )