Dynamically changing the value in Conditional split

Question

Dynamically changing the value in Conditional split

vipin_jha123

Hall of Fame

Points: 3085
More actions
January 5, 2016 at 8:30 am

#310651

Hi All,
I have source flat file , I want to exclude the records containing below state.
I have created one variable which data type is string and value is as given below
State == "AA" || State == "AE" || State == "AP" || State == "AS" || State == "FM" || State == "GU" || State == "MH" || State == "MP" || State == "PR" || State == "PW" || State == "VI" || State == "00" || State == "99"
In Conditional split when I am using that variable I am getting error as below screen shot.
Kindly help me to achieve my requirement

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246978 More actions · Answer 1

vipin_jha123 (1/5/2016)
Hi All,
I have source flat file , I want to exclude the records containing below state.
I have created one variable which data type is string and value is as given below
State == "AA" || State == "AE" || State == "AP" || State == "AS" || State == "FM" || State == "GU" || State == "MH" || State == "MP" || State == "PR" || State == "PW" || State == "VI" || State == "00" || State == "99"
In Conditional split when I am using that variable I am getting error as below screen shot.
Kindly help me to achieve my requirement

Cannot see any screen shot.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

vipin_jha123 Hall of Fame Points: 3085 More actions · Answer 2

Sorry for that

Hope you understand the issue.

I want to pass the filtr value in conditional split by variable so that in future if I want to add some more filter I can add it without touching the code

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

I don't think you can assign the condition(s) to a variable like you're trying to do.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

vipin_jha123 Hall of Fame Points: 3085 More actions · Answer 4

Please suggest the way by which I can get the solution

Phil Parkin SSC Guru Points: 246978 More actions · Answer 5

vipin_jha123 (1/5/2016)
Please suggest the way by which I can get the solution

You could try using FINDSTRING() instead.

FINDSTRING(@[$Package::StateExcludeNames], [State], 1) == 0

where [State] is the data column and

$Package::StateExcludeNames is a string parameter (easily configurable from SSISDB)

= "AA,AE,AP,AS,FM,GU,MH,MP,PR,PW,VI,00,99"

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel