Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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