Hi
All
ihave a file like this
company id,price,product, startdate,enddate
1 , 10 ,a ,1/1/07 ,6/1/07
1 , 20 ,a ,4/1/07 ,6/1/07
...
....
here all products end date 6/1/07
but iwant product a enddate(3/1/07) at price rate is 10..
result:
company id,price,product, startdate,enddate
1 , 10 ,a ,1/1/07 ,3/1/07
Hi
Moderators: chulett, rschirm, roy
Welcome to DSXchange, madhava1238.
If this post has topic other than 'Hi', would seem to be a better one.
I have a few questions.
1. What is your Source here? Which kind of file you came to annote?
2. What is transformation you need to do? Is it always to do that making the END_DATE is a constantwith PRICE 10.
Please help me help you.
If this post has topic other than 'Hi', would seem to be a better one.
I have a few questions.
1. What is your Source here? Which kind of file you came to annote?
2. What is transformation you need to do? Is it always to do that making the END_DATE is a constantwith PRICE 10.
Please help me help you.
Last edited by ag_ram on Fri May 16, 2008 4:52 am, edited 1 time in total.
-
- Participant
- Posts: 15
- Joined: Mon May 05, 2008 5:12 am
- Location: chennai