This content has been marked as final. Show 1 reply
Since the table name is used only in QlikView and has nothing to do with the actual name of the QVD file, why don't you use the same table name but store it using the name you want? Something like
// load all data extractsfor each File in filelist(loadPath &'\*.csv') // define tblNmlet pthNm = '$(File)';let stNm = index('$(pthNm)','Polo');let endNm = index('$(pthNm)','Extract_') + 7;let tblNm = mid('$(pthNm)',$(stNm),$(endNm)-$(stNm)); Table:Load *FROM$(pthNm)(txt, utf8, embedded labels, delimiter is ',', msq);Store Table into $(qvdPath)\$(tblNm).qvd(qvd);drop table Table;next File
Hope that helps.