split the names

[consulting]

I have a text file which have a name column it contains 140000 names starting from alphabe A-Z with duplicate entries
it want to load it into files asper the name (ie name starts with A into one file starts with B to another file ...........)

in sql we can achieve it by where names like "A%" same how to get in datastage

[ArndW]

You can split the stream using a switch or transform or filter stage (I'm sure that there are others I've overlooked)

[ray.wurlod]

Transformer or Filter stage with 26 outputs (one for each letter) and one rejects/otherwise link.

A Switch stage is not appropriate; it switches on specific values, so you might need 140000 separate switch conditions!

[PhilHibbs]

A Switch stage is not appropriate; it switches on specific values, so you might need 140000 separate switch conditions!

Could you pick out the first character in a prior stage, and split on that? (I don't know parallel stages)

[ray.wurlod]

Yes, but that stage would have to be a Modify or Transformer stage. If the latter, then you may as well take the outputs from it directly.

[PhilHibbs]

Just as in C a switch statement is more efficient than nested if...elses, I thought a switch stage might be more efficient than a transformer with 26 conditional outputs.

[ArndW]

I was thinking of the Switch on the first letter, but as Ray has pointed out, you would need a transform/modify stage in the job, so you might as well use the transform to split the streams.