Execute Business Rules defined in a file using Variables

[Anonymous]

Hello,

I would like to know if it's possible to define business/format rules (e.g FIELD == null ?0:1) within a file and execute them from Talend by defining variables.

Here's an example. I have this file (Campos_Reglas in the Job) where I've defined the next rules for each column (PRODUCTO, COD_PROVEEDOR and NOMBRE_PROVEEDOR are the columns in the Input😞

I've defined the fields as variables (tFlowTolerate) and then I've created a tMap to call them:

This is where I got stuck cause I don't know how to execute the rules (defined in my file) with just calling the variable.

Is there any expert who can solve this?

Thank you!!

[Anonymous]

Hello,

You can achieve ternary operator in tMap component.

The expression should be:

condition?value if true:value if false

 For more information, please have a look at this article about:

https://community.talend.com/t5/Design-and-Development/tMap-expression-syntax/ta-p/21575

Best regards

Sabrina