Load certain data using WHERE criteria

[Anonymous]

Hello,

I am trying to load only data where the following criteria is met:

Where[Prem Category Description]='SINGLES' AND [MI Sub Status Type]='CA'

Where do I put this statement in the load script?  I am having trouble getting it to work.

Thank you!

[sunny_talwar · Accepted solution]

After the from or resident table

LOAD FieldName

From YourDataSource

Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';