Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
After the from or resident table
LOAD FieldName
From YourDataSource
Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';
After the from or resident table
LOAD FieldName
From YourDataSource
Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';