SWITCH Stage - with wild card character

[karthi_gana]

All,

As the switch is not working properly, the lights are not glowing and i am unable to watch TV. i am sitting in the dark now. Can anybody fix the issue and help me to watch TV?

I am just kidding

Coming to the issue, I have designed a simple job as below.

Code: Select all

Seq_File --> Switch --> Seq_1
                             --> Seq_2
                             --> Seq_3

my case expression is as below

• Switch_18: Parse error on case string: isin like 'A%' = 0, isin like 'B%' = 1, isin like 'C%' = 2;
  multiple `=' tokens were seen.

My input file has a column called 'isin'. my requirement is,

A) If the 'isin' starts with 'A' store it in a file (A.txt)
B) If the 'isin' starts with 'B' store it in a file (B.txt)
C) If the 'isin' starts with 'C' store it in a file (C.txt)

Note: I used Filter stage for this and it worked fine. Although i have read about SWITCH in the manual and came to know it works similar to FILTER. Thats why i tried to know what is happening.

simply, will SWITCH stage support WILD CARD condition check? If yes, what i am missing here.

[karthi_gana]

any inputs/thoughts pls ?

[ray.wurlod]

Read the manual about what wildcard character is supported. Tip: it's not the percent sign.

[karthi_gana]

I have searched on the manual (under switch stage). It doesn't say anything about handling wild card character.

Note I have also tried A*. But it didn't worked

[kandyshandy]

Did you just try

Code: Select all

like 'A'

?

[ray.wurlod]

Asterisk works for me. How are you quoting the literal string?

[karthi_gana]

Switch_18: Parse error on case string: isin like "A*" = 0, isin like "B*" = 1, isin like "C*" = 2;
multiple `=' tokens were seen.

I tried single quote too.

[chulett]

FWIW, I checked the 8.5 docs for both the stage and the operator and found no reference to any 'wildcard' character.

[Kryt0n]

Are you writing all that on one line or creating multiple case statements?

Are you actually stating "isin like" within your case? You may need the like but the isin (which I'm assuming is your input column) should be specified within the selector

[ray.wurlod]

My bad - I was thinking about the Filter stage.

Here's a rule of thumb: Filter stage filters using expression, Switch stage filters using value. Value does not permit the use of wildcard or, indeed, any comparison other than "equals".

[karthi_gana]

yeah..This is what i wanted to know...

Thanks for all