This topic has been marked "Resolved."
This topic is not resolved, but there is a WORKAROUND.
Author
Message
deesh
Participant
Joined: 08 Oct 2007
Posts: 184
Points: 1841
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,
I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.
Could you help how to reach, Moreover will get multiple files same day with different dates.
1job source files:
ABCD09112016.dat
ABCD10112016.dat
ABCD11112016.dat
ABCD12112016.dat
ABCD13112016.dat
2job source files:
EFGH09112016.dat
EFGH10112016.dat
EFGH11112016.dat
EFGH12112016.dat
EFGH13112016.dat
ray.wurlod
Participant
Group memberships: Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 54166
Location: Sydney, Australia
Points: 293772
Assuming that the file name is a job parameter, you can manipulate that.
For example
Code:
Convert(Convert("0123456789", "", jpFileName), "", jpFile ...
_________________ RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
deesh
Participant
Joined: 08 Oct 2007
Posts: 184
Points: 1841
Achieved by the file name column property in sequential file stage
Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Powered by
phpBB
© 2001, 2002 phpBB Group
Theme & Graphics by
Daz :: Portal by
Smartor
All times are GMT - 6 Hours