Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Re: Load column if exists

I see try this and I rest my case 😄 I am sure it will work now

if date#(subfield('$(ftime)',' ',1),'YYYY-MM-DD')>date#('2013-04','yyyy-mm') then

 

 

View solution in original post

Highlighted
Creator
Creator

Re: Load column if exists

It finally does work, but it doesn't go to the else Load where it doesn't load the QvdDate column:

2019-10-10 16:25:34 0011 if date#(subfield('2013-02-01 08:05:13',' ',1),'YYYY-MM-DD')>date#('2013-05','yyyy-mm') then
2019-10-10 16:25:34 0013 User:
2019-10-10 16:25:34 0014 LOAD Date(Date,'DD/MM/YYYY')&O_SHORT_DESC as [Version Manager],
2019-10-10 16:25:34 0015 [First Name],
2019-10-10 16:25:34 0016  [Middle Name],
2019-10-10 16:25:34 0017 [Surname],
2019-10-10 16:25:34 0018 [Email],
2019-10-10 16:25:34 0019
2019-10-10 16:25:34 0020 date(Date,'DD/MM/YYYY')&USR_HOME_ENTITY_ID as VersionID,
2019-10-10 16:25:34 0021 [User Name]
2019-10-10 16:25:34 0022 FROM [C:\Users\ME\Desktop\USER\USER2013-01.qvd] (qvd)
2019-10-10 16:25:34 Error: Field 'Date' not found
2019-10-10 16:25:36 Execution Failed
2019-10-10 16:25:36 Execution finished.

Highlighted
Creator
Creator

Re: Load column if exists

Got it to work, changed the date# to the general date format.

if date#(subfield('$(ftime)',' ',1),'YYYY-MM-DD')>date('41365','yyyy-mm-dd') then

View solution in original post

MVP & Luminary
MVP & Luminary

Re: Load column if exists

Why not just use "Load *" for everything?  Won't that pick up the date field if it exists?

-Rob