Each of these categories contains their own buildup of rows and information. My plan is to make 5 different load script, 1 for each category. And that would be pretty easy to do if there were only 1 file pr. category, and the unique value i would use for the "where" function is a value that could change from one day to another. (if the meter or sensor is replaced)
But my problem, and also the reason for this question is that it is not just 1 file pr. category, it is 2.000 files pr. category on a daily basis, 2.000 individual files (1 daily file for one unique meter number)
So I was hoping that it was possible to make a dataload, where the dataload would look in a Meterlist file, to locate what files to load.
I got confused a couple of times writing this question, so I would perfectly understand if you did as well.