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: 
lalitkgehlot89
Creator II
Creator II

How to pick data from multiple sheet & Multiple File.

Hi,

In current scenario in have Month wise data file like Jan18, Feb18, Mar18 and so on.

And each file has Day wise sheet like Day1, Day2, Day3 and so on. Sheet in File & file in Data folder create on the basis of day & Month.

I want to pick that data in Qliksense. Please let me how to pick all the data automatically. 

2 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Lalit,

Please refer below thread it may help you.

Load multiple excel files from Multiple excel sheetsinto QV

Thanks,

Prvind Patil

rubenmarin

Hi Lalit, the "For Each" help provides a sample of how to iterate through folders:

https://help.qlik.com/es-ES/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...

Adapted to read all xlsx in sense can be:

sub DoDir (Root)

      for each File in filelist (Root&'\*.xlsx')

        LOAD

            '$(File)' as Name,

            FileSize( '$(File)' ) as Size,

            FileTime( '$(File)' ) as FileTime

        autogenerate 1;

      next File

  for each Dir in dirlist (Root&'\*' )

      call DoDir (Dir)

  next Dir

end sub

call DoDir ('Lib://ConectionName')