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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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