DSXchange

my input values are in this hierarchy format:- depth,name 1,a1 2,b1 3,c1 1,a2 and i want output in this format:- 1 2 3 a1 a1 b1 a1 b1 c1 a2 i m using this logic:- d=stageveriable for o/p col1 if depth=1 then input.name else d f=stageveriable for o/p col2 if depth=2 then input.name else f r= stagever...

Hi crouse
Thank you for your reply ....it is working in sever job..

3 cols in the input file:- depth name 1 A 2 B 3 C1 3 C2 3 C3 2 B1 3 c4 3 c5 1 A1 2 B3 3 C6 3 c7 My condition is that:- IF depth=1 then its Distributor IF depth=2 then Its FES IF depth=3 then Its RETAILER now output should come like this:- o/p col:- distributor FES RETAILER A B C1 A B C2 A B C3 A B1 ...

How to change the extended properties of the field? I am new to DataStage PX. I tried the following, but got some error. StringToDate(Convert('-','',Date_Column),"%yyyy%mm%dd") Error: Failure during execution of operator logic Conversion error calling conversion routine date_from_string d...

Hey everybody......really dsexchange is best forum on data stage,and i learned a lot after joining this forum.[/b]

Hey everybody......really dsexchange is best forum on data stage,and i learned a lot after joining this forum.[/b]