Qlik stored data into subfolders (concat problem)

[ioannagr]

Hello guys. 

I created daily qvds (format: DD/MM/YYYY) and Qlik stored them in a very weird way.

It created a folder for every 'DD' months.

Then in it there are subfolders  for the 'MM' months.

Then in every 'MM' subfolder there are all the 'YYYY' years.

So for example Qvd01  contains Qvd_01 to Qvd_12 ,and Qvd_01 contains years 2000, 2001, 2002 and so on.

How do I concatenate these data from all subfolders???

This is a first timer and i have no clue.

[JordyWegman · Accepted solution]

Hi,

This is because '/' is a path in Windows. You should remove the '/' and always store as YYYYMMDD, this is also better for sorting the files!

Jordy

Climber

[ioannagr]

Yes @JordyWegman  that was it! Thanks 🙂