
Contributor
2019-11-19
04:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
596 Views
1 Solution
Accepted Solutions
2019-11-19
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1 Reply
2019-11-19
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
