input like
2 7 8
9 5 1
7 3 6

output:2 5 6 how to find out this plz explain?

Answer Posted / deepanshu

supposing single column is there having values
278
951
736

sol'n :
Use transformer string function with @inrownum variable.

inputcolumn[@inrownum,1]
will give you desired o/p

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What could be a data source system?

587


How to reverse the string using unix?

2825


I have a few records just I want to store data in to targets cycling way how?

1909


How many types of hash files are there?

624


What are routines in datastage?

795






Differentiate between Join, Merge and Lookup stage?

658


What are the different kinds of views available in a datastage director?

611


what is ds administrator used for?

734


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1767


What are the types of views in datastage director?

1258


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1628


If you want to use a same piece of code in different jobs, how will you achieve this?

805


root tree will find which is server job and which is parallel job?

1461


What is a merge?

683


What is merge stage?

777