Hi everyone, I'm very new to using QlikSense on Desktop, and would like to learn how to use the data load script. Specifically:
1. The files I am working with:
Row 1 = Name of column group. This I may need to get rid of when load the data since I have no use for them.
Row 2 = Name of field. This will be what I want to load data by.
Row 3 on ward = Data
2. What I want to do:
3. Please note that I'm fairly new to QlikSense, so please "teach me how to fish" - explain to me step by step (ie: Step 1 - Convert data to QVD file; Step 2 - Load data dynamically; Step 3 - How to use the file name to make up new field) and the syntax if possible. I've searched around and see that several others have asked similar question, but I can't understand the answer given, so please "don't just give me the fish, cause I don't know how to cook that fish".
Your time and help are much, much appreciated!!
look at this: https://www.youtube.com/watch?v=CqvINEVAr8w
this is a nice topic, where you can see maybe a solution for your issue, if you have hourly your report in excel, so you can create in each folder within of excel and load dynamically.
i hope that helps
I have got multiple excel files in a folder in my local machine how can i upload it in qliksense using Data Load Editor ?