I have a column A(in string) :
I use a tMap to put the number in double. So, i have that :
#DIV/0! (disappears) #DIV/0! (disappears) #DIV/0! (disappears)
So, I use in Expressions :
but it doesn't work.
I want keep "#DIV/0!" in Excel. I want keep numbers in double.
Thank you in advance
Solved! Go to Solution.
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!"
@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.
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.
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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.