Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lalitkgehlot89
New Contributor III

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

Re: How to pick data from multiple sheet & Multiple File.

Hi Lalit,

Please refer below thread it may help you.

Load multiple excel files from Multiple excel sheetsinto QV

Thanks,

Prvind Patil

Re: How to pick data from multiple sheet & Multiple File.

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')

Community Browser