Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

psenthilbtech
New Contributor

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
Valued Contributor

Re: Loading Data from Specific sheets in Excel

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
New Contributor

Re: Loading Data from Specific sheets in Excel

Hi Bruno,

Thanks .

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

brunobertels
Valued Contributor

Re: Loading Data from Specific sheets in Excel

isingh30
Contributor III

Re: Loading Data from Specific sheets in Excel

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
Contributor III

Re: Loading Data from Specific sheets in Excel

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.

Community Browser