How to write if condition on multiple is not empty fields in formula tool

[swethav]

Hi,

I have 3 fields(CA1,CA2,CA3) as below . I need output as 1.SMITH, 2.ROCH, 3.HEALTH for not empty columns and for empty columns I want it as 1.KIN in my target column TEXT.

CA1	CA2	CA3
KIN
SMITH	ROCH	HEALTH
KIN	BRIDGE
KIN	AMERI
MORGAN	KIN	CARE

Target :

TEXT

1.KIN

1.SMITH, 2.ROCH, 3.HEALTH

1.KIN, 2.BRIDGE

Please help me to get the result. 

Below is the condition I am using in formula tool for all three non empty columns but I am getting null() in my output.

If (! Is Empty ([CA1]) and ! Is Empty ([CA2]) and ! Is Empty([CA3]))
then "1."+[CA1]+"2."+[CA2]+"3."+[CA3]
else null()
endif

[atcodedog05 · Accepted solution]

Hi @swethav 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @swethav 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

[swethav]

I want five years back date . Date value is 2023-06-18 . I want five years back date . By using below I am getting only year .

Please help me

[atcodedog05]

Hi @swethav 

remove tonumber() function and datatype should be date or string.

datetimeadd([Cuccess],-5,'year')

[swethav]

It is giving Null result