Lookup space separated values individually

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
roshanearly
Participant
Posts: 27
Joined: Thu Aug 09, 2012 4:55 am
Location: bangalore

Lookup space separated values individually

Post by roshanearly »

hiii

i have data coming in a table separated by space . i wish to lookup each value from the lookup table individually and enter them in db separately

Input: abc ghi jkl def

Lookup table is like :

abc 1
def 3
ghi 4
jkl 2

Output should be like:

1
4
2
3

i am not getting how to do the separate the data and lookup individually.also the number of fields coming is not fixed
ROSHAN
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Field() functions in Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply