Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
psenthilbtech
Contributor III
Contributor III

Loading Data from Specific sheets in Excel

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

5 Replies
brunobertels
Master
Master

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       

psenthilbtech
Contributor III
Contributor III
Author

Hi Bruno,

Thanks .

But in my scenario, it should read the data only from specific sheets. Any input on how to achieve this

isingh30
Specialist
Specialist

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.

kaanerisen
Creator III
Creator III

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.