I keep receiving this error message and I'm not sure what the fix is.
Please advise! Thank you.
Hi @kimberlyka you need put 'OR' after any expression, like this
[Field1]='A' OR [Field1]='B' OR [FIELD1]='C' etc etc etc
[COUNTERPARTY_CATEGORY] ="3rd_Pty" OR [COUNTERPARTY_CATEGORY]="INTERCO_NON-IHC" OR [COUNTERPARTY_CATEGORY]=" " AND [TEMPLATE_NAME]="DERIVATIVES" OR [TEMPLATE_NAME]= "OTHER_ASSETS_LIAB"
Try the above out. Your original had an unnecessary " after the first OR and there was also an AND operator that was missing a space afterwards.
After applying 'OR'
[COUNTERPARTY_CATEGORY] = "3rd_Pty"OR [COUNTERPARTY_CATEGORY] = "Interco_Non-IHC"OR[COUNTERPARTY_CATEGORY] = ' 'OR[TEMPLATE_NAME] = "Derivatives"OR[TEMPLATE_NAME] = "Other_Assets_Liab"OR[TEMPLATE_NAME] = "Banking_Book_Securities"
I now receive "Parse Error at char(26): An operator must be between operands"
