input like
2 7 8
9 5 1
7 3 6
output:2 5 6 how to find out this plz explain?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhavani
we can acheive this using transformer stage:
1. Check the record count using AGGREGTOR stage and have a column count
2. In the transformer initiate a loop with condition @ITERATION <=count. and loopvar = @iteration
3.if @INROWNUM = loopvar then right(left(@iteration),1) --> output value
Now the result will be 2
5
6
Let me know if this is correct.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are datastage sequences?
How can remove duplicates in a file using UNIX?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
How to initialize environment variables?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
How to remove blank spaces from data?
How to lode data in sequntional files perform faster?
Demonstrate experience in maintaining quality process standards?
Can you explain repository tables in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?