DSXchange

Thanks Ray

Is there a parallel routine in your home page for AddMonth()

Thanks Ray for this routine on your home page. I went through the routine for AddMonth() I want to use this routine in the transformer stage and add 6 months to the current date. I created a server routine and compiled it. It works fine. I am using PX 7.5.2 I have never called a transform routine in...

Hi All,

Thanks it works fine now. I converted them to dates and compared using greater than or lesser than signs.

Thanks

So I just use the StringToDate function for both the input columns and compare using the following expression

svDate1=StringToDate(input.Date11)
svDate2=StringToDate(input.Date22)
svComp=svDate1>svDate2

where svDate1, svDate2 are date datatype
Is this right?

I have to compare two dates. My source fields are varchar(10) columns. e.g. in the format 2003-12-10 I order to compare I plan to change the format to YYYYMMDD format. How do I remove '-' in them? Is it that after removing them I need to convert these varchar field to decimal using StringToDecimal f...

Nice post helped me resolve my issue

Yes the lookup has the continue option selected

I have a simliar issue... Dataset | | (3 records) but showing 10 records | Dataset-------------> Lookup--------------------------------> sequential file 10 records 10 records (showing 10 records) (showing 10 records)

I gues PART would be in which partition the data is in and PARTCOUNT is the number of partition on which the job is running..

Take the first dataset with 100 records and use the sort stage to sort and remove duplicate records. Set Allow duplicates to true in the sort stage We can capture the duplicate records using the create change key column option under the stage-> properties tab This new key would have the value of 1 f...

Thanks Ray. I am not sure if you understand the question: Reference file contains: ACCT,ACCOUNT,TRUST Input records are BANK ACCOUNT CREDIT ACCT TRUST ACCT HAPPY WORLD Now we need to check the occurance of the words in the reference to the input file... Output Column name, Occurance BANK ACCOUNT, 1 ...

Hi All, I have a requirement to count the number of occurance of a substring in a string. I am aware of the count function which does this for us. The issue is that the substring values are 8 and I have to use this function 8 times... with OR condition between them. This is fine also. But these 8 su...

But I have a requirement to create a fixed width file and for some output columns extend the field length.
How should i proceeed.

Thanks Ray for the reply.
So you say when we have the fixed width file we must not use VarChar to read or write rather use Char datatype