Hi, In the tmap, the formula must return a value that will be assigned to the output column of your schema. Then, you can't use if/then/else statements in it. Instead, use conditional operator "?" like this : (condition) ? then_value : else_value That is the ternaire condition Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Hello, Yes, but (condition) ? then_value : else_value in the then_value, (or in the else_value or the both), is it possible to have two actions, one who assign a value in the output column, and another as cpt+1 to display it after ? Best regards, Quartz
Sabrina, In a tMap, I have this expression to assign a value in output column : !Relational.ISNULL(File_Ei.NAME)?File_Ei.Name:"NoName" and (in more) I want count how many input null and no null I have. Can I do : !Relational.ISNULL(File_Ei.NAME)?File_Ei.Name Var.cptnoNull+1:"NoName" Var.cptNull+1 for displaying the two counters after, in an another steep. More generally, is it possible to have more than one action in then_value or/and else_value in a ternaire condition ? Thank you for answer ... Quartz