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.
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.
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
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.
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:
It works
Thanks a lot
Hugo M.