Load certain data using WHERE criteria

Anonymous — Thu, 14 Jan 2016 16:27:50 GMT

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!

Re: Load certain data using WHERE criteria

sunny_talwar — Thu, 14 Jan 2016 20:01:50 GMT

After the from or resident table

LOAD FieldName

From YourDataSource

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