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
- 12283 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
SeqFile---->Sort---->Trms---->Dataset
Sort_Stage: Key=Company (Or) Name
Trms
----------
SV=Company
SV1= If dslink.Company=SV Then SV+1 Else 1
Add (count) column in Transformer stage
Map SV1 stage variable to Count column (SV1=Count)
Will get desired output..
Plz correct me if am wrong....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a merge in datastage?
sed,awk,head
What are the job parameters?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Demonstrate experience in maintaining quality process standards?
How can one find bugs in job sequence?
What are the differences between datastage and informatica?
How to reverse the string using unix?
What is the sortmerge collector?
How to RD using transformer?
What can we do with datastage director?
Why do we use link partitioner and link collector in datastage?
Lookup constraints
project Steps,hits, Project level HArd things,Solved methods?
