Dynamic data load via web origin

[marcel_olmo]

Hi guys,

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

Product	2014	2015	2016	2017	2018
ProdA	10	15	8	9	16
ProdB	11	14	9	8	17
ProdC	12	13	10	7	18

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 :

Product	2015	2016	2017	2018	2019
ProdA	15	8	9	16	19
ProdB	14	9	8	17	20
ProdC	13	10	7	18	21

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

[marcus_sommer]

You could just use:

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

- Marcus