Dynamic data load via web origin

marcel_olmo — Wed, 08 Aug 2018 10:54:45 GMT

Hi guys,

I'm trying to load a table via web like this :

The point is that it always retrieves the last 5 years, so if I'm trying to load the same table the next year, the data load would be :

If I want to automate the data loading, it has to be with the "no labels" option.

How could I do it dynamically?

Regards, Marcel

Re: Dynamic data load via web origin

marcus_sommer — Wed, 08 Aug 2018 10:58:20 GMT

You could just use:

crosstable(Year, Value, 1) load * from file;

- Marcus