June 29, 2009 at 1:07 pm
I am pulling data from a flat file and I want to do a conditional split - to which I have not needed to use until now. I want to look at each row that comes in from the flat file and if a specific field has a value of say "Blue" I want to direct that row to a given output name - else I will send the data to the default output.
How do I do a condition to compare a column value to a constant string value..
[Exception] == "Blue"
Is not working where Exception is my column name in question.
Thanks,
Ad.
June 29, 2009 at 2:13 pm
How do you know it is not working, are you getting an error or are no rows going out the "blue" dataflow?
You need to make sure you match case and length, so make sure you either trim the source or pad the comparison.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 29, 2009 at 2:20 pm
It is working now - I am not sure what I was doing, but it is amazing what happens when you walk away for awhile and come back to try again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply