topic Re: tMap : #DIV/0! disapperars in Talend Studio

tMap : #DIV/0! disapperars

Anonymous — Thu, 26 Apr 2018 09:40:07 GMT

Hi !

I have a column A(in string) :

#DIV/0!

116

147

#DIV/0!

I use a tMap to put the number in double. So, i have that :

~~#DIV/0!~~ (disappears)

116

147

~~#DIV/0!~~ (disappears)

So, I use in Expressions :

row4.ColumnA.equals("#DIV/0!")?Double.toString(row4.ColumnA):row4.ColumnA

but it doesn't work.

I want keep "#DIV/0!" in Excel. I want keep numbers in double.

Thank you in advance

Re: tMap : #DIV/0! disapperars

manodwhb — Thu, 26 Apr 2018 10:42:21 GMT

@Beauchamp_J,are you looking for the following?

Re: tMap : #DIV/0! disapperars

Anonymous — Thu, 26 Apr 2018 10:58:42 GMT

No, I always want see "#DIV/0!" in my Excel.

But, when i put the column in double, Talend doesn't keep "#DIV/0!". I need them to stay because there are informations linked to the "#DIV/0!"

Re: tMap : #DIV/0! disapperars

manodwhb — Thu, 26 Apr 2018 11:00:35 GMT

@Beauchamp_J,in to double column you cannot populate sting value as #DIV/0!. if you want numbers into one column and string value into another column you can do.

Re: tMap : #DIV/0! disapperars

manodwhb — Thu, 26 Apr 2018 11:07:26 GMT

@Beauchamp_J,please check this wil be usefull.

Re: tMap : #DIV/0! disapperars

Anonymous — Thu, 26 Apr 2018 11:18:25 GMT

Thank you for that solution but i can't have two columns. (in my Excel, it is many column with number, SUM, DIV....) I just keep three columns (A= ID, B= Name and AF= Number and DIV/0!) (and other columns (D, E, F, G, ....) aren't filtered)

I will try to use tReplace.

Re: tMap : #DIV/0! disapperars

Anonymous — Thu, 26 Apr 2018 13:07:56 GMT

@manodwhb

I added a tMap more with your proposition and this works!

I needed take a pause and i had a idea after.

Thanks for your help.