Hi Team,
I am working on excel adapter. My Source is Excel and Destination is JSON. I facing data related issues. Please help me out.
Issue1:
My input file is having mathematical functions (mainly addition + and subtraction -). I have one to one mapping. When I execute the map, it is printing the same data.
Input: 100 + 200 - 50
Output: 100 + 200 - 50
I want the final value i.e 250 after calculation. Please help me with this.
Issue2:
My input cell having value 0 and it is formatted with $, I am getting $ 0 in the output. I don't want to print $ in my output. My output should be "0".
------------------------------
Hemachandra G
------------------------------
#SupplyChain#B2BIntegration