DSXchange

use this: field ("james alex 1234 usa", DCount("james alex 1234 usa", " "))

let me knw if u didnt get it

thx

hey, u can do as count the total number of filed delimiters i.e spaces.
From there do -1 from that you will get the last string of that row,
let me know if you did not get this process.


Thx

As far I understood
by using lookup we can get this, send the 'IMONo' data for a reference link and all the data again send to direct link, by which make a lookup/join with rownum, which will place appropriate values.
let me know if this process does not work.

Thx

to my sense what you are saying is looking like simple, but the logic i mentioned should work for summation. transform like this Cust Date Amt 123 10113 10.00 123 10113 5.00 123 20113 20.00 and send it ti aggregator and group by first two columns and in otions take for calculate and sum for o/p colm...

so far we do peer review meeting with all the technical people in which you mainly check with naming standards and review codes and process explanation. Here we there will be producer & reviewer Producer is the one who developed the job. Reviwer is who will be validating the job, as verifying al...

As far i understood, just make date as start of month first and change it to varchar and group it.
group first two columns, i think you will be able to get it.
let me know if i am wrong.

Thx

StripWhiteSpace function in transformer

or CompactWhiteSpace try this