About EasyMorph Tutorials & Examples Web-help

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


#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


#5

It works

Thanks a lot

Hugo M.