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
What could be a data source system?
How to reverse the string using unix?
I have a few records just I want to store data in to targets cycling way how?
How many types of hash files are there?
What are routines in datastage?
Differentiate between Join, Merge and Lookup stage?
What are the different kinds of views available in a datastage director?
what is ds administrator used for?
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?
What are the types of views in datastage director?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
If you want to use a same piece of code in different jobs, how will you achieve this?
root tree will find which is server job and which is parallel job?
What is a merge?
What is merge stage?