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;
Accepted Solutions
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
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
