Multi-Field to Create new field

[aman_goyal]

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.

[atcodedog05]

Hi @aman_goyal 

Please change the datatype to string in the highlighted option.

Hope this helps : )

[binuacs]

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

[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.

[atcodedog05]

Hi @aman_goyal 

We wont be able to check the workflow data flow without the input file. Can you please provide the input file.

[aman_goyal]

Please check above screenshot, no data available is coming after run the workflow. PFA input file and check.

[binuacs]

@aman_goyal the data is showing for me in the  browse tool. Can you add a output tool and try

[atcodedog05]

Hi @aman_goyal 

It clearly mentioned here that you need to run the workflow to see the output. I guess that's the issue.

Hope this helps : )

[aman_goyal]

@atcodedog05 ,

I have run the workflow, not able to see the result.

@binuacs, Thanks for your help, your workflow is working with browse tool, Did you update something? As I cannot find some updates and I cannot use browse tool because after this need to do more transformations.

Please write here what you have updated?

[binuacs]

@aman_goyal I didnot make any changes in my workflow