How to pick data from multiple sheet & Multiple File.

[lalitkgehlot89]

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. 

[arvind_patil]

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