DSXchange

and use only Input--->Remove Dups--->Output.
Use the input column sorting/partitioning in Remove Duplicate stage. No need to use Sort Stage for your requirement.

You have to make sure that you are selecting partitioning and sorting for COL1 and only sorting for the remaining columns.

1: Define two Stage Variables as svLoopControl and svColumns 2: svColumns = Delimited Column names and svLoopControl = Dcount function to get the total number of columns from svColumns with Delimiter Value. 3: Define two Loop Variable as lvCount and lvColumns. 4: lvCount = lvCount + 1 and lvColumns ...

Why you are not using Remove Duplicate Stage??

What have you tried so far?

Hi Swathi,
Please set APT_NO_PARTSORT_OPTIMIZATION as described here https://www-304.ibm.com/support/docview ... wg21517119

Hope this will help you.
Thanks

Hi Criag,
Just wondering how to use stage variables to track the records with a number and add one after that for ones that do not?
Just wondering.
Thanks.

If you are using DS 8.5 or above, consider using Transformer Loop function. For reference check http://newtonapples.com/datastage-trans ... looping-1/

Or if you are using DS 8.1 try using key break logic viewtopic.php?p=423754

Use this code:
This will check mylink.mystring for Numeric Values (0-9) only. If true it will return 1 else 0.

Hope this helps

Check it. Your total amount will not be null in case if one or more amount fields are null. It will only add the numeric values.

One options is to use Unix script in before job subroutine and get the total of all 4 amount column. For this you can use something like awk '$6+=$5+=$4+=$3' where $n is the column number with amount fields. This will remove your first transformer. You will end up using one transformer to filter out...

What have you tries so far?
Try using copy stage and see how it goes.

One way is to remove all the double quotes in Before-job subroutine and use , as delimiter.

Please see this viewtopic.php?p=212053&sid=c442a53e4274 ... 2f93ae0167

and this
http://publib.boulder.ibm.com/infocente ... Stage.html

Hi,
Just use this #DSJobStartDate# at the end of the file name. So in your case the exact name for the file will be as follows:
abcd_#DSJobStartDate#.txt

Hope this helps.