Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Lalit,
Please refer below thread it may help you.
Load multiple excel files from Multiple excel sheetsinto QV
Thanks,
Prvind Patil
Hi Lalit, the "For Each" help provides a sample of how to iterate through folders:
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')