Hello, I have six collums col1, col2, col3, col4, col5, col6 and i need to map them.
Example from col4 i have to map to cod2 colum but if the col4 is null or empty i sould get the data from col5 if is not null, but if its col5 is null i have to get it form col3.
How and i do this in tmap with a expression.
Solved! Go to Solution.
Here is the required expression:
row1.col4 != null && !"".equals(row1.col4) ? row1.col4 : row1.col5 != null ? row1.col5 : row1.col3
Hope this helps