DSXchange

Hi all,

I want to know whether the conversion of the field in constraint will work or not.

because if i am directly mapping the Inlink.Field1=Lkuplink.Field1 its working. then why conversion not working?

Hi all,

I want to know whether the conversion of the field in constraint will work or not.

because if i am directly mapping the Inlink.Field1=Lkuplink.Field1 its working. then why conversion not working?

Hi all, I used debugger but I could not able to point out where the problem is.. after I tried with different constraints one of them is Oconv(Iconv(Inlink.Field1,'D MY[A3,2]'),'D-YMD')= LkUplink.Field1 where Inlink.Field1 has 'Mar 08' i am converting it to 2008-03-01 and LkUplink.Field1 has 2008-03...

Hi all, I am joining two tables like tbl1, tbl2 having 10 fields and 4 fields each having Inlinktbl1.Field1 and Inlinktbl2.Field2 as key columns -----------------ODBC --------------------| --------------------| ODBC------->TRF------->ODBC I am taking 9 fields from tbl1 and 3 fields from tbl2 and usi...

Hi all, I am using stage variables, to get the updated fields alone , i.e, I am having 3 fields of which one field is primary key Inlink.Field1, Inlink.Field2, Inlink.Field3 Mar 08 465155 'akjdfkjfd' Jun 08 645553 'djkfdkafj' Feb 08 464885 'hdahdgfd' Outlink.Field1, Outlink.Field2, Outlink.Field3 Fe...

LkUp is done on the transformer. I had checked the conditions and logs no errors or warnings are found.

plz any one suggest some ideas

thanks in advance

I forgot to include few more things, Lkup | | ODBC--->TRF -------->ODBC i am using the constraint, Dslink20.field1 from Lkup(hash file) it has the value '2008-03-01' (only this record) and the constraint used is AllowCmon='Y' Field1 is the primarykey No rows were written to the output ODBC,

Hi all, I am using stage variables, to get the updated fields alone , i.e, I am having 3 fields of which one field is primary key Inlink.Field1, Inlink.Field2, Inlink.Field3 Mar 08 465155 'akjdfkjfd' Jun 08 645553 'djkfdkafj' Feb 08 464885 'hdahdgfd' Outlink.Field1, Outlink.Field2, Outlink.Field3 Fe...

Take a look at the available Transforms, particularly MONTH.TAG, MONTH.FIRST and MONTH.LAST. Since the latter two return internal format dates, if you subtract 1 from the result of MONTH.FIRST you ... I am using the following code to get the next month starting date, MONTH.FIRST(MONTH.TAG(Iconv (DS...

Hi ray

No it's from the DS Transform

NullToZero(%Arg1%) only I had used,

If I am not knowing about what its doing against primary key field? how reliable will my data as i had populated with it already?

so I need to clarify about its behaviour

Thanks for your reply

Hi all, I am having on scenario like.. I want to allow the records for the previous month and again after a month it has to be repeated with previous month incremented. for example there are 4 fields inthat Inlink.Field1 has value like 'May 08' Inlink.Field1 Inlink.Field2 Inlink.Field3 Inlink.Field4...

Hi all, I had unusual behaviour when I used NULLTOZERO against the composite primary key, obiviously primary key field will not be NULL. But unfortunately I tested this function, it's returning only zero value, its not taking the value in that field. for example below are the four fields, in that In...

ray.wurlod wrote:

pxraja wrote:

ray.wurlod wrote:

Code: Select all

Oconv(Iconv(Field(DSLink2.Field1," ",1,1),"DYMD"),"DQ")

Or, if you want an ISO 8601 "quarter t ...

Hi all,

Thanks for your ideas and suggestions, the above quote has resolved the problem

battaliou wrote:You can aggregate your sorted data on the key and choose "last" option for your date. This will function the same as a remove duplicate stage.

Hi all,

Thanks for your ideas, ray's idea is working and i ll try the above quote too

ArndW wrote:StageVar: InternalDate = ICONV(Inlink.field2,'D MY[A3,2]')
Derivation: OCONV(InternalDate,'D4Y'):'Q':OCONV(InternalDate,'DQ') ...

Hi all,

Thanks for your ideas, either of two is working fine, QUARTER.TAG and the above quotes has resolved