+5Hi all,
I want to replace not equal to "0" to "1" and if any value missing replace to "0"
Original
Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8231212301235650231230231000031240000370232102312234340000320001220023232123120127700
Expected result
Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8110110010100001000011010111000010001001110110000
Please advise
Best answer by takashi
I would firstly use the NullAttributeMapper to replace every missing, empty, or null attribute with 0, then use the ExpressionEvaluator to assign 1 to every non-0 attribute.
+45Hi @venu
I created your case here with only two transformers.
StringReplacer - to find any number more than 0
NullAttributeMapper = to find <missing> values and replace to 0
Results:
Attached the Workspace template - FMWT.
Workspace_Replace_Values.fmwt
Thanks,
Danilo
I would firstly use the NullAttributeMapper to replace every missing, empty, or null attribute with 0, then use the ExpressionEvaluator to assign 1 to every non-0 attribute.
+5I would firstly use the NullAttributeMapper to replace every missing, empty, or null attribute with 0, then use the ExpressionEvaluator to assign 1 to every non-0 attribute.
thank you very much
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
