Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

Dynamic data load via web origin

Hi guys,

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

 

Product20142015201620172018
ProdA10158916
ProdB11149817
ProdC121310718

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 :

 

Product20152016201720182019
ProdA15891619
ProdB14981720
ProdC131071821

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

1 Reply
marcus_sommer

You could just use:

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

- Marcus