Closest value in a currency exchange csv

1

Hi
I have a currency exchange table...
I need that when there's no data in a specific day (for instance, Xmas, New Year) the last existing value will be used.

Is there a way to do that in EasyMorph?

Thanks

Hugo M.

2

Hi Hugo,

It looks like the "Fill down" transformation would do the trick. It fills empty cells with the nearest non-empty cell above.

***Moved to General Q&A

3

Hi
The problem is the date...

The table is more or less

Date USD
2017-12-29 0.9
2018-01-02 0.89

Thanks

Hugo M.

4

Use the "Calendar" transformation to generate a sequence of dates. The use "Merge" in the full join mode to merge that sequence of dates into your table.

Example:

image
image535×445 11.1 KB

5

It works

Thanks a lot

Hugo M.