Table Not Dropping

haymarketpaul — Wed, 25 Nov 2020 16:16:04 GMT

QV12 SR3

I have the following code that loads from multiple files into a table then stores the table in a QVD and then drops the table.

For some reason there is always a table left in the QV application that happens to be the name of one of the files loaded - Any ideas why that file still resides? Wondering if it is something to do with me using a preceding load?

Table being left behind after code below runs........

Code...........

SMDaily:
LOAD
     *
     ,ApplyMap('MapCountriesToContinents',[SM Country])                        as [SM Continent]    
     ,Date(Floor([SM Event Datetime]))                                        as [SM Event Date]
     ,If([SM Event]='Sent campaign',Date(Floor([SM Event Datetime])))        as [SM Sent Date]
     ,Time(Timestamp#([SM Event Datetime],'DD/MM/YYYY hh:mm:ss'),'hh:mm')    as [SM Event Time]
     ,'Yes'                                                                    as [SM 1st Party Email Opt In]
     ,'Yes'                                                                    as [SM 3rd Party Email Opt In]
;
LOAD 
     ApplyMap('MapEmails',Lower(Trim(email)))        as [SM Email],
     membership_number        as [SM Membership #], 
     first_name                as [SM Firstname], 
     surname                as [SM Lastname], 
     ApplyMap('MapSMDailyCountries',Upper(country))    as [SM Country],  
     event_display_label    as [SM Event], 
     Timestamp(Timestamp#(timestamp,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')    as [SM Event Datetime],consistency
     membership_grade        as [SM Membership Grade], 
     link_label                as [SM Link],
     job_title                as [SM Job Title], 
     company                as [SM Company]
FROM
[$(vCIPSSMDailyInc)SM*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq)
Where daily_email = 'Y'
;

STORE SMDaily INTO $(vQVDPath)SMDailyInc.qvd;
DROP Table SMDaily;

Re: Table Not Dropping

sunny_talwar — Tue, 13 Jun 2017 12:11:23 GMT

WildCard loads have problems with Preceding loads. In this case, you can use for loop instead of using a wild card load

Wildcard data loading (*.blah......)

Snippet from the above blog bost

Re: Table Not Dropping

haymarketpaul — Tue, 13 Jun 2017 13:29:21 GMT

Thanks Sunny - that's perfect

topic Re: Table Not Dropping in QlikView

Table Not Dropping

Re: Table Not Dropping

Re: Table Not Dropping