Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexis_Pala12
Contributor
Contributor

QVD historico

Hello, I need to perform a progressive upload in a Qlik Cloud script of a file called "Provisiones_202511" and "Provisiones_202510". For now, I know that the upload will continue with the same naming convention, from 202301 to 202601, and so on. Which would be the best option?

Labels (4)
1 Solution

Accepted Solutions
Daniel_Castella
Support
Support

Hi @Alexis_Pala12 

 

Do you mean to concatenate all the files in a loop? You can do it by replacing some of the numbers with an *.

 

For example:

LOAD Field1, Field2...

FROM [.../Provisiones_202*]

 

This will load all the files that begin with "Provisiones_202". Hence, the ones from 2020 to 2029. If it needs to load through 2030 you can write it like this:

LOAD Field1, Field2...

FROM [.../Provisiones_20*]

 

Let me know if this works for you.

 

Kind Regards

Daniel

View solution in original post

1 Reply
Daniel_Castella
Support
Support

Hi @Alexis_Pala12 

 

Do you mean to concatenate all the files in a loop? You can do it by replacing some of the numbers with an *.

 

For example:

LOAD Field1, Field2...

FROM [.../Provisiones_202*]

 

This will load all the files that begin with "Provisiones_202". Hence, the ones from 2020 to 2029. If it needs to load through 2030 you can write it like this:

LOAD Field1, Field2...

FROM [.../Provisiones_20*]

 

Let me know if this works for you.

 

Kind Regards

Daniel