Multi-Field to Create new field

Dear Community,

I have multiple columns having numeric (Type- Double) columns, I want to check validity of each column like length, not null etc. Using Formula tool, unable to implement multiple columns like 100 columns.

So used Multi-Field column as below-

IF Not (IsNull([_CurrentField_])) AND IsNumber([_CurrentField_])
THEN 'Data source value is valid'

ELSEIF IsNull([_CurrentField_])
THEN 'Data Source Value is empty'

ELSEIF Not IsNumber([_CurrentField_])
THEN 'Data source value format is incorrect'

ELSE 'Data source value length is incorrect'
ENDIF

I am getting error because input columns are numeric and am trying to create string field for output as below:

Is there any way to achieve this, that proper message will display and string columns can generate to check validity of data.

PFA workflow (small implementation) and suggest the solution.

New Workflow- Multi-Field.yxmd

Workflow

Developer

Developer Tools

Custom Tools

Parse

Accepted answers

atcodedog05

Hi @aman_goyal

It's working for me also

Hope this helps : )

New Workflow-Multi-Field (1).yxmd

All comments

atcodedog05

Hi @aman_goyal

Please change the datatype to string in the highlighted option.

Hope this helps : )

binu_acs

@aman_goyal an update to the @atcodedog05 suggestion, when you change the data type change the size as well to fit the strings

New Workflow- Multi-Field.yxmd

aman_goyal

@atcodedog05 ,
Thank you. It works!!.
I have one problem, I have 950+ columns, if I run the same process for 950+ columns then output not generates. Can you please check workflow and suggest.