Update new columns basis on other columns using formula

[Tid14]

Hi,

I am working on alteryx workflow where in excel file have data as:
Material No. Part Number Now
null 712
null 712
null 712
405 712
405 712
395 672
null 672
null null
null null
null null
100 null
100 null

Now from the above data, I want in my output that if i know that the rows in which
,aterial number and part number is linked are correct and for eg-
If in any case material number and part number are linked (405 abd 712 or 395 and 672)
so in the case where material number is null and part number is something which is already linked in the data
then in new column I want "DC but cataloged"
written indicating that we have material number for this.
And for other examples like where material number and part number both are null or where material number is 100
and part number null then in those cases New column output for those rows hsould be null only.
How can we do this in Alteryx?

[OTrieger]

@Tid14 

There are many ways how to deal with this.

You can do it with a Formula tool, with IF condition

Or with Multiple Fields Formula tool

You can use Filter first to find where you do not have null

Even you can do it with Join tool

The idea will be to have a condition that checking if one of the Fields in Null while the other one is not and based on it add the needed comment.