Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have one doubt could you please help me in this.
I have data like below
Raw data sheet and Exchange sheet. attached here.
Could you please let me know how can i achieve this requirement.
Find out the Start date & End Date in the fact table (Raw Data) and identify the latest Exchange Rates for the currency only get one more additional column as Exchjnage Rate in the output file
Is this just a sample or full data set?
What result do you expect for the first line in Raw Data(which currency)?
At the moment you have one exchange rate for each currency.
i guess, you can load your data using SORT BY in the end of your load
and than create a variable and use peak() where you input your table, your column and tell the function to find the last row (-1)