LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi Team,

I need to select records based on below conditions and load it in target file, Can you please suggest syntax or logic for the following condition .

conditon to use to extract records:
----------------------------------
dept-id in between '5000' and '5099' and location = '30', '31', '32', '33'

Thank you for all your support.

Regards,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

In a filter:



emit *
where 'Dept-Id'>= "5000" and 'Dept-Id'<="5099"
and (Location=='30' or Location=='31' or Location=='32' or Location=='33')

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rhallmark

The code you provided Stony may not have the desired effect if the 'Dept-Id' happens to be '501'. I'd recommend converting the Dept-Id to a number first. See below:

emit *
where 'Dept-Id'.long()>=5000 and 'Dept-Id'.long()<=5099
and (Location == "30" or Location == "31" or Location == "32" or Location == "33")