Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unexplained syntax error

;

syntax error missing/misplaced from load

Not sure why I get this. I do not get any red brackets in the code.  Is there a way to troubleshoot unexplained syntax errors

load

/*To format the IDI flag*/
if( (match([D Investor],'FNMA') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
    (
match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
   
match([D Investor],'VA','PRIVATE / REG AB')  or
   
match([D Investor],'FHA') and Match([Product Type],'FHAHAMP'), 'Y',
   
   
if( (match([D Investor],'FNMA')and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
    (
match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
   
match([D Investor],'VA','PRIVATE / REG AB')  or
   
match([D Investor],'FHA') and Match([Product Type],'FHAHAMP'),'N')) as IDI

*
;

load

if ([IDI]='N',trial4_due_dt= .,([4th Trial Made])= .),

*
;

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Do you need a comma after as IDI

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Do you need a comma after as IDI

jpapador
Partner - Specialist
Partner - Specialist

Like Bill mentioned you need a comma after IDI but before the *.  Also in your second load statement, you may need single quotes around the period in your if statement.

Not applicable
Author

Thanks Bill

Not applicable
Author

thanks