Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a requirement where i need to read the data from a specific excel file.
Exa:
The Excel file has 4 Sheets
1.Sol
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
Regards,
Senthil
Hi
See this post
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
you may find the way to achieve your requierment
Hi Bruno,
Thanks .
But in my scenario, it should read the data only from specific sheets. Any input on how to achieve this
Hi
So my be this post from omar bensalem will help you
https://www.linkedin.com/pulse/dynamically-load-multiple-sheets-from-excel-qlik-omar-ben-salem/
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.
Hi Senthil,
MasterTable:
LOAD *
FROM
[lib://Directory/International.xlsx]
(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.