DSXchange

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.

Hi puli.reddy,

Try this,

OCONV(@DATE,"DY"):OCONV(@DATE,"DM[2]")

Hope this helps

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...

Congratulations!

Thank You for all the great help

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...

Check this post if you are running on Windows XP SP2

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

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...

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...

Hi murali,

Use the Aggregator stage Grouping on the keys and do a Count on any one of the key.
You can use the aggregator stage after the transformer.
This will give you the number of times the composite key has appeared in the source odbc1.

Hope this helps

Hi Craig,

Thanks a ton

Hi Craig,

I had searched the forum before posting the message but unfortunately was not able to find the required info.

Any help on this is appreaciated.

Thank You,

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,

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...

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...