Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could just use:
crosstable(Year, Value, 1) load * from file;
- Marcus