tMap : #DIV/0! disapperars

Seven 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


Accepted Solutions
Thirteen Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,please check this wil be usefull.

Untitled.pngUntitled.png

Manohar B

All Replies
Thirteen Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,are you looking for the following?

Untitled.pngUntitled.png

Manohar B
Seven 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!"

Thirteen 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
Thirteen Stars

Re: tMap : #DIV/0! disapperars

@Beauchamp_J,please check this wil be usefull.

Untitled.pngUntitled.png

Manohar B
Seven 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.

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.