Hi Edward,
Substrings(Source.Col,1, Len(Source.Col)-2)
Left(Source.Col,Len(Source.Col)-2)
I am sure there are many more ways of achieving the result.
Search found 127 matches
- Wed Feb 08, 2006 12:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: truncate trailing zeroes
- Replies: 9
- Views: 2103
- Fri Feb 03, 2006 3:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: About @DATE
- Replies: 9
- Views: 8513
- Thu Feb 02, 2006 4:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to check for the blank lines in an excel file.
- Replies: 2
- Views: 951
Hi Anshuman, Since you are working on the Unix Server you might be converting the excel files to csv. While reading the files using the sequential stage you can give the set the Incomplete Column property to Discard and Warn . This will lead to all the blank lines being eliminated. Also when you run...
- Thu Feb 02, 2006 4:01 am
- Forum: Site/Forum
- Topic: Craig hits 5000 Posts!
- Replies: 9
- Views: 6447
- Wed Feb 01, 2006 11:02 am
- Forum: Site/Forum
- Topic: My Charter Membership!!
- Replies: 19
- Views: 15128
I feel the knowledge that I have gained from this site is not comparable to $$$. I am also grateful to all the Gurus who have spent their time in answering questions and sharing their valuable knowledge for nothing in exchange. I express my gratitude and support to the dsxchange community by becomin...
- Mon Jan 23, 2006 6:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Properties of job_activity & Routine Activity
- Replies: 4
- Views: 1414
Check this post if you are running on Windows XP SP2
- Fri Jan 20, 2006 9:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to specify rows in a single column
- Replies: 4
- Views: 1846
Hi kayarsenal,
Input
1234
1234
3435
1253
3455
3534
Output
1,1234
1,1234
2,3435
3,1253
4,3455
5,3534
If this is the output you are expecting then look at the solution at the end of this post.
viewtopic.php?t=97751
Input
1234
1234
3435
1253
3455
3534
Output
1,1234
1,1234
2,3435
3,1253
4,3455
5,3534
If this is the output you are expecting then look at the solution at the end of this post.
viewtopic.php?t=97751
- Fri Jan 20, 2006 5:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtract the value from Previous row value
- Replies: 11
- Views: 5119
Hi Smita, This can easily be done using RowProcCompareWithPreviousValue as already suggested. Declare 2 StageVariables: StgCompare=RowProcCompareWithPreviousValue(Source.ID) StgNew=if StgCompare=1 then StgNew else StgNew+1 Transformer Derivation for the Column New: New=StgNew Output: 1,5,2 1,5,7 2,7...
- Fri Jan 20, 2006 5:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: count for no of rows
- Replies: 7
- Views: 2960
Hi Vijay, Your previous post gave me the impression that you wanted the total count of the number of times the composite key is repeating. You can implement the logic for your last post by using a transform RowProcCompareWithPreviousValue and a sort stage Target---->Sort---->Transformer---->Target S...
- Thu Jan 19, 2006 1:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: count for no of rows
- Replies: 7
- Views: 2960
- Wed Jan 18, 2006 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command for finding the bit size of the hashed file
- Replies: 4
- Views: 1266
- Wed Jan 18, 2006 1:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command for finding the bit size of the hashed file
- Replies: 4
- Views: 1266
- Wed Jan 18, 2006 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command for finding the bit size of the hashed file
- Replies: 4
- Views: 1266
Command for finding the bit size of the hashed file
Hello Friends,
Which command can help us find whether the previously created hashed file is 64 bit or 32 bit?
We have tried with Analyze.file and it does not specify the bit size of the file.
Thank You,
Which command can help us find whether the previously created hashed file is 64 bit or 32 bit?
We have tried with Analyze.file and it does not specify the bit size of the file.
Thank You,
- Tue Jan 17, 2006 11:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ROW TO COL
- Replies: 17
- Views: 7475
Hi kayarsenal , If I understand your question correctly then You need to reject all the records that have the NO present in the hash file And for this customer number in the rejected record, you need to reject all the remaining orders Input ID NO AMT 0000 Y345 7 0000 Y346 5 0001 Y322 4 0001 Y341 6 0...
- Tue Jan 17, 2006 6:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ROW TO COL
- Replies: 17
- Views: 7475
Hi, Are u reading the input correctly? There is no need of the NO column to be present in the hash file. Why are the values from the NO column present in your hash file? Your Input File has 3 columns i.e. ID NO AMT So when u do view data on the souce stage you get 3 columns. Your delimiter for sourc...