I am reading an excel spread sheet with the following attributes:
Column A: Date
Column B: Int
Column C String
I then have to perform some manipulation work on each row and output to another excel sheet. One of the things I need to do is test if the input column C is null and if it is, to leave the entire row blank in the output sheet. I have attempted several different variations of using a ternary expression in tMap to accomplish this, but with no luck. I then switch to an if statement, again in the tMap, but also ran into trouble here. Can someone help me with a solution. I am racking my head on this and need someone with more experience to help me get past this hump.