Forum Discussion
Excel Query: Custom Column
Hello,
I have an excel file with two queries with external data sources linked to a sharepoint: Purchase Item List and FX_Rate which is just a connection. Purchase Item List has a column 'Unit Price in Local Currency' with prices in different foreign rates. FX_Rate has the exchange rate to USD. I want to add a column to Purchase Item List called "Unit Price in USD" that converts the foreign rate to USD using the conversion rates in the second table. Below are the sample tables that represent both tables. Please help me to achieve that.
We can use column 'Currency' in table Purchase Item List and column 'local currency' in table FX_Rates to achieve a connection between the two tables. And this is where I am stuck and can't move any further.
Thanks in advance,
Al
- Update: I found the solution to this. After researching some more, I was able to achieve the expected result by merging the two queries and creating a third query.
1 Reply
- Update: I found the solution to this. After researching some more, I was able to achieve the expected result by merging the two queries and creating a third query.