You are not logged in.
Inside a tmap I try to do some calculations using a var... Mathematical.INT(row1.Column31)*0.01 (as double) and I put the result on an Excel file.
Is it a way to pre-format the excel column as 12345.60 instead 123455.6 and 123.00 instead 123 ?
Also I try to use if statement on the same TMAP var row:
something like excel function:
is it a way to do use "if" statement on tmap vars?
many thanks !
you can use "if" statement like this: row1.Column32=="D"?row1.Column31:""
for tMap vars
Many thanks shong !
However I still have an issue :
the output row1.Column32 on an excel cell is "D" (without ")
the StringHandling.LEN(row1.Column32) is 1
however the test row1.Column32=="D" is always false !?!
rem: The D value comes from a csv file ....,"D",....
I did a different test :
and it works in my case as a workaround, however I don't understand why the test :
is not working...