DSXchange

hHi, INPUT --> OLDKEY | 1234 1234 1234 1111 2345 2345 Output required ---> OLDKEY | NUMBER 1234 | 001 1234 | 002 1234 | 003 1111 |001 2345 |001 2345 | 002 What i am doing is using a stage variable which stores SvCurrentOLDKEY -- Stores current oldkey Sv PreviousOLDKEY -- Stores the previous key SvNU...

[quote="Kryt0n"]Title - if count(customer_name, ',') = 0 then customer_name else ''[/quote]

Thanks Kryton....i had already tried the same yesterday and this was not working.
but today somehow this is working!!!!!!


Will close the thread now.

Thanks everyone for the replies. Now requirement has changes. INPUT---> CUSTOMER_NAME CHAR(60) hadley,chris,mr the occupier customer keith,ray a ,miss OUTPUT REQUIRED IS TITLE | FIRSTNAME | MIDDLE NAME | SURNAME mr | chris | | hadley the occupier | | | customer | | | miss |ray |a | keith Now to popu...

[quote="Sainath.Srinivasan"]You can do a regular expression match in Oracle itself (in source SQL). In DataStage, you can do an Index()[/quote] can you give me any example of INDEX function.as i have already build the job i dont want to change anything on input end due to some other constr...

Hi, My input table consists of Customer titles like owner ,occupier,customer with combination of "the" either "a" Customer Title OCCUPIER OCCUPIER,OWNER THE CUSTOMER A CUSTOMER EXECUTIVE EXECUTIVE THE Output requires --> I have to search the customer table and suppose if it conta...

hey ray,

Sorry about that, actually i am not a premium member hence was unable to read the post as it was marked premium.

so is there no way that i can handle this approach!!!!

[quote="chulett"]Do you know what the [i]maximum[/i] installment count can be? ...[/quote]

Unfortunately, No
and thats why i am stuck

But may be we can take installment count = 50 ( at the max) for now to get going with this.

Current Scenario----> There is a customer table with customer number and number of installments taken by them.A date for payment is also set Input Table ---> CUSTOMER_NO INSTALLMENT_NO DATE 123 2 12-03-2009 Required Output We need to generate the installment dates for the customer.Suppose there are ...

[quote="chulett"]For example: Field(Link.N_NAME_SEEK,",",1,1) = First Name Field(Link.N_NAME_SEEK,",",2,1) = Last Name Field(Link.N_NAME_SEEK,",",3,1) = Title ...[/quote] I used Stage variable in Transformer stage with this function and this works!!!!! Thanks ...

Problem : I have a column named : N_NAME_SEEK Data in this column is as under : N_NAME_SEEK joe,robot,mr jain,juhi,miss lee,bruce,dr I want to split this data in 3 respective fields, FIRST NAME,LAST NAME,TITLE So output i want is : FIRST NAME LAST NAME TITLE robot joe mr juhi jain miss bruce lee dr ...