Manipulating excel with null values

Anonymous — Wed, 04 Jul 2018 20:44:14 GMT

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.

Re: Manipulating excel with null values

Jesperrekuh — Thu, 12 Jul 2018 21:48:12 GMT

Concatenate all columns and seperate it with a delimiter like ;
this concatenated string is your output if column C is not null / has a value.
in tmap you test for column C ... if not then concat else ";;" empty string
Next
is get the concatenated string back to columns with tNormalize and for item seperator use the ;

Easy... =|;-))

topic Manipulating excel with null values in Talend Studio

Manipulating excel with null values

Re: Manipulating excel with null values