Interested to Buy Any Domain ? << Click Here >> for more details...
souce file having the columns like
name company
krish IBM
pooja TCS
nandini WIPRO
krish IBM
pooja TCS
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
- 9 Answers
- 11966 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
Use below stage variables
create 4 stage variables
STG1 =NAME:COMPANY
STG2=1
STG3= IF STG1:STG4 THEN STG3+1 ELSE STG2
STG4= STG1
create extra column for store this ranks.
After this stage use the sort stage to sort the data based on ranking column.
Then will get the exact output what we are looking.
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
What is the difference between odbc and drs stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are iconv and oconv?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is merge stage?
What is ibm datastage flow designer?
What is the difference between server job and parallel jobs?
On which Dimension Table you implemented SCD Type in your Project
What are the functionalities of link partitioner?
what are the errors,warnings in datastage
Highlight the main features of datastage?
Describe the architecture of datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the different plug-ins stages used in your projects?
