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: 
sined
Contributor
Contributor

load data qlik sense

Hi All,

I want to know whether we have a solution to load data from excel if the name of the excel file is maintained on version wise eg.

data_V1.xlsx

data_V2.xlsx

version number will keeps on increasing every month when the data get extracted but file name will be like, data_V3.xlsx, data_V4.xlsx.

I want to keep into sense all the  data field. Not only the last.

Regards

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP

You can, Perhaps

Load * From [lib://Connection_Name/data_V*.xlsx];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni
MVP
MVP

You can, Perhaps

Load * From [lib://Connection_Name/data_V*.xlsx];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful