Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
GDondapati1602160294
Contributor
Contributor

Price conversions to different currencies by looking up into the main table in Tmap

Hi All,

I have a lookup table which consists of currency_from, currency_type, conversion_rate and a main table which has price ,noofparts,currency_from.

I have joined both into tMap. Where I want conversions. In the output I need price of different currencies

Like, usd, Europe etc..,,..

Currency_from is Ind.. and currency_to has euro, usd... Etc.

The output table should be like..usdptrice,europrice...etc..

Thanks​

3 Replies
manodwhb
Champion II
Champion II

@Gnaneswar Dondapati​ , You need to write custom java code to do or if you have some api with that you can try to use that API.

 

Thanks,

Manohar

GDondapati1602160294
Contributor
Contributor
Author

Hi Manohar,

I have a solution in my mind but unable to implement.The solution would be like first we should store them in the context and should call accordingly.Can anyone please guide me with a better approach.

Thanks,

Chandu. ​

GDondapati1602160294
Contributor
Contributor
Author

Hi Manohar,

If you could provide a sample java custom code it would be grateful.

Thanks,

Chandu​