Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a requirement where i need to read the data from a specific excel file.
The Excel file has 4 Sheets
2. Data for Field1
3. Data for Field2
4.Data for Field 3
The Requirement is i need to pull all the data from the sheets which has the names starting with Data for Field.
Need your input on this. Attaching you the sample excel file
See this post
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
you may find the way to achieve your requierment
But in my scenario, it should read the data only from specific sheets. Any input on how to achieve this
So my be this post from omar bensalem will help you
Main Script - Table Files - Select your file - Excel format - Table - Drop down(Contains all the tabs of the sheet)
You can select the file from the drop down.
(ooxml, embedded labels, table is [Data for Field*]);
This will get all data table in sheets which name starts with "Data or Field"
Hope it helps.