I have a bunch of data in the excel sheet and from talend I read those data and insert into the table. But when the amount is negative it still inserted as a positive number and that's why I am getting the wrong total of amount.
Example :: value = (100) is equivalent to -100.
Negative value comes in ().
I tried this but it's not working.
StringHandling.RIGHT(row27.line, 1).equals("(") ? "-" + StringHandling.EREPLACE(row27.line, "(", "") : row27.line
@TRF Can you please help me out.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema