About EasyMorph Tutorials & Examples Web-help

Closest value in a currency exchange csv


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?


Hugo M.


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 #uncategorized


The problem is the date…

The table is more or less

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


Hugo M.


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.



It works

Thanks a lot

Hugo M.