Need to convert one currency rate to another in excel usong talend.

[Anonymous]

Hi Everyone, I have an excel sheet with one column with one currency rate eg: INR I need that to be in USD in my output excel file is there any way to implement that through the talend studio. I am really new to this. Can anyone help me?

[Anonymous]

Hi,

    You can easily do it with Talend.

     If the conversion is only limited to INR to USD, you need to pass the conversion rate as parameter to the job or read from a DB table or query from a webservice to get the output. The result of the query need to store in a context variable.

     Once you complete this task, then in the next subjob, you can do a multiplication of INR value to USD with the conversion factor in tMap. it will be some thing like below.

row1.input_data*context.conversion_rate

    Once this mapping is done, you will get the output value in USD.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

If you are having multiple values like USD, GBR etc, then you need to store the conversion rate in a table first.

eg:-

USD     0.75

GBR     0.01

   Now, you need to do a join the target currency column of input flow with currency column of lookup using inner join. After inner join, the steps remain same as previous post.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

How to pass a parameter to the job. can you please elaborate. Or specify any link which has good content.

there are two JVM parameter or context parameters.

[Anonymous]

Hi,

    I would suggest you to first go through the below link to understand the concept of context variables.

https://help.talend.com/reader/JdTBzKszzXoWvjpEJD3EBA/xbhyQKORQNX5V8yw8WAb8w

    For example, please refer the below post which is having similar query.

https://community.talend.com/t5/Design-and-Development/resolved-Passing-variable-context-value-from-...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂