Need support in conditional checks with multiple columns

[Suryachoppakatla]

Hello,

I would like to write a formula where the condition should give me the desired result as mentioned below
1. Based on the Recipients US TIN, the column should be able to identify if given data is for Entity or Individual, I do not mind if additional column need to be added
Example : If the TIN number starts with 3 (digits)-2(digits)-4(digits) - then it is Individual (eg: 123-22-1234)
                 If the TIN number starts with 2 (digits) - 7(digits) - then it is a Company (eg: 12-1234567)
2. Based on the above condition the "Recipient Last Name" should be able to determine if it belongs to Entity or Individual. If the client provides his TIN number
starts with 3 digit and writes his Company name in "Recipient Last Name", then the result should throw as Invalid because 3(digits) belongs to Individual
I tried using "Startwith" formula, but not able to figure out how to write the condition, so that Alteryx understand my formula and gives me desired result 

Any help is highly appreciated

 Regards,
Surya

[ShankerV · Accepted solution]

Hi Surya, 

Please find the solution.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Solution 1: If U and then US then Valid

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Solution 2: If U and then USA then Invalid

[Felipe_Ribeir0 · Accepted solution]

Hi @Suryachoppakatla 

Please see if i undestood it correctly

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Solution 3: If U and then United States then Valid

Feel free to reach out to the community, if you have more questions.

[Suryachoppakatla]

Thank you Felpie for your help.