Multi-Field to Create new field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@aman_goyal an update to the @atcodedog05 suggestion, when you change the data type change the size as well to fit the strings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @aman_goyal
We wont be able to check the workflow data flow without the input file. Can you please provide the input file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please check above screenshot, no data available is coming after run the workflow. PFA input file and check.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@aman_goyal I didnot make any changes in my workflow
