Six Stars

tMap : #DIV/0! disapperars

Hi !

 

I have a column A(in string) : 

12

10

48

16

27

24

#DIV/0!

116

147

#DIV/0!

#DIV/0!

#DIV/0!

 

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

 

12

10

48

16

27

24

#DIV/0!    (disappears)

116

147

#DIV/0!   (disappears)

#DIV/0!   (disappears)

#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

1 ACCEPTED SOLUTION

Accepted Solutions
Eleven Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,please check this wil be usefull.

Untitled.pngUntitled.png

Manohar B
6 REPLIES
Eleven Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,are you looking for the following?

Untitled.pngUntitled.png

Manohar B
Six Stars

Re: tMap : #DIV/0! disapperars

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!"

Eleven Stars

Re: tMap : #DIV/0! disapperars

@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.

Manohar B
Eleven Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,please check this wil be usefull.

Untitled.pngUntitled.png

Manohar B
Six Stars

Re: tMap : #DIV/0! disapperars

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.

Six Stars

Re: tMap : #DIV/0! disapperars

@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.