DSXchange

Sort your input records before the transformer and inside the transformer

1. svOld: svNew
2. svNew: <KeyColumn>
3. svCol2: If svOld <> svNew Then svCol2 + 1 Else svCol2

Map this svCol2 to your Col2

Use Field function to extract the words based on the delimiter Anbu, creating the delimiter is my problem. I cannot replace the entire word with @FM using convert nor I can use that word as delimiter in the field function. In server I can write the derivation like, Field(Ereplace('Arun Kumar','Kuma...

No Anbu. My requirement is to split the input string into two, if the words are not equal maximum words should be on the second column. No. of words are dynamic in the input. Eg., Str = "One Two Three Four" O/P: C1 = 'One Two" C2 = "Three Four" If Str = "One Two Three F...

Use Field function to extract the words based on the delimiter Anbu, creating the delimiter is my problem. I cannot replace the entire word with @FM using convert nor I can use that word as delimiter in the field function. In server I can write the derivation like, Field(Ereplace('Arun Kumar','Kuma...

My requirement is to split the incoming string based on the no. of words. If the source data has four words, my output should be C1 - first 2 words and C2 - next 2 words. If there are 7 words, C1 - 3 words and C2 - next 4 words. I can count the no. of spaces and div by 2 and find the word from which...

Or you can even use Count...

If the NLS is EBCDIC, it will convert the data to ASCII.

Also, dtx is to convert decimal to hex right? Will it convert EBCDIC to ASCII?

Yes, I was even searching for it and found that there is no equivalent function in PX for server 'ereplace'

But I believe ereplace will work in BASIC_Transformer.

I too had a similar problem where the job activity before the end loop behaved as it had the 'Unconditional' trigger. I included a Nested condition between the job activity and the end loop and defined something like EXXXX_AddDetailAndTrailer.$JobStatus = DSJS.RUNOK and connected this to end loop. I...

If you do not have any constrain, It will be left.

If you want a inner join use Not(<LookupLinkName>.NOTFOUND) in the constrain.

Balu, I think you had the same question in a different post. Please refer your old post

Just include Line = '' in the begining of your routine

Yes it will. We are upgrading and they did a POC and it worked.

You can use the code as suggested by Anbu with a little modification

Nm:Zinman, Dr Bernard (Mount Sinai Hospital, Toronto)
svLastNm=Field(Nm,",",1)
svFirstNm=Field(Field(Field(Nm,",",2),"(",1),' ',Count(Field(Field(Nm,",",2),"(",1),' ')+1)

You should be able to change it to Custom SQL, I'm not sure why it is not enabled for you. And for Iconv((),'d4') will convert any of the following dates to internal format, if it is a value other than a valid date, it will convert it to NULL. July 4, 2002 July 4 02 4 July 2002 4 July 02 4 JUL 02 4 ...