SAP Knowledge Base Article - Preview

1182965 - How to implement "Not In" operator in Query transform - SAP Data Services

Symptom

  • SQL transform supports the 'Not In' operator
  • Example of using 'Not In' operator - ProductID not in (1,2,3) 
  • Query returns validation error when 'Not In' operator used in Where clause

 

 


Read more...

Environment

SAP Data Services

Product

SAP Data Services 2025 ; SAP Data Services 4.0 ; SAP Data Services 4.2 ; SAP Data Services 4.3 ; SAP Data Services XI 3.2

Keywords

DS, in, not in, operator, comparison , KBA , EIM-DS , Data Services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.