DSXchange

I was able to use the count function as follow:

SUM(COUNT(RecordType3 Loop:File) + COUNT(RecordType4:Loop:File))

and I was able to get the desired results..


Thanks!

Hello everyone, I need help to count number of records from my source file and write it to the output.. The format of my source file is as follow: I have multiple record types in my file. RecordTypes 2,3 & 4 are under a Loop . For instance RecordType1 (1:1) Loop(1:9999) RecordType2 (1:1) RecordT...

Bob, Thanks! for the response. But there are lot of values possible for BilledRatedAsQualifier and each one of them has a different description. The only place these values and it's description is available is in the Restriction list that is setup for this element. I was hoping to read the value fro...

Hello, I am new to Datastage and need some help with map designer. I need to know if there a way to do a lookup in the map on the element restriction list ?. For Example : In a X12 210 invoice, there is a element BilledRatedAsQualifier and it has a include restriction list as follows: Include Descri...