We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Problem with pulling data from CSV based on condition split transform

sqlcurious
sqlcurious asked
on
Medium Priority
265 Views
Last Modified: 2012-05-11
Hi experts,
I am using the following conditions to extract data from a csv file, please find attached the screen shot of the conditions in the condtiional transformation editor but it is missing out getting one record from the csv file(it is loading all the records with the below conditions except one record) and I am guessing something to do with the condition.
LEN([Merchant Reference Number]) <= 10 && Applications == "Credit Card Settlement(Accept)"
LEN([Merchant Reference Number]) <= 10 && Applications == "Credit Card Credit(Accept)"
I want to load records which definitely should have LEN([Merchant Reference Number]) <= 10  and Applications == "Credit Card Settlement(Accept)" or "Credit Card Credit(Accept)"
Is my above conditions wrong then, should I put it some other way?

filters-cybersource.jpg
Comment
Watch Question

what are the values of the merchant reference number and applications column  for the record that gets missed.
Chris MangusDatabase Administrator
CERTIFIED EXPERT

Commented:
Try this:

LEN([Merchant Reference Number]) <= 10 && (Applications == "Credit Card Settlement(Accept)"
||Applications == "Credit Card Credit(Accept)")

Note that the characters between Settlement and Credit are a logical OR condition.  Review this at:  http://msdn.microsoft.com/en-us/library/ms141061.aspx
Database Administrator
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
thnks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.