DSXchange

The date format yyyy-mmm-dd should be able to parse your input field - unless it is case sensitive but that would be silly! That way you don't need to figure out what month it is Ya date format is same as above but i want to is any other function to achieve like eg:DaysSinceFromDate similar to days...

svMon=Upcase(Field(Inputdte,"-",2)) svMM=If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' Else .. svNewDt=Field(Inputdte,"-",3) : '-' : svMM : '-' Field(Inputdte,"-",1) Convert your input date to yyyy-mm-dd and then use above function i analysed your derivati...

Hi anbu ,

bit confused ,

Suppose my batch date is 15-apr-2010 so i have calculate how manys days are there from 01-01-2010.how to achieve dis

thx for your rply.

Let me analyze.

Hoew derive the no of days from starting of the year to current date in datastage.

Please help on this.

Thanks,

Hi All, Please help out how to fix the following warning .My job has 11 dataset reference with driven dataset and performing the left outer join in the lookup stage. How to resolve this warning When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-...

Which is exactly what I gave you does. How will checking the first three characters of "INT1" or "INT2" for "INT" fail? :? ... Hi Chulett, I want to populate If Input.Column = 'INT%' Then column else 0.hence i want to know how achieve wild card '%' in datastage. Thanks...

Use the substring operators to check to see if the first three characters = "INT". For example: If Link.Column[1,3] = "INT" then this else that ... Hi Chulett, Thanks For the Reply. But Then part will be performed only if it "INT",Even imay get like INT1,INT2 etc Then ...

Hi All,

I have requirement where i have to do If Input.Column like 'INT%' then Column else Other Column.

Please help out in solving.

Thanks in advance,

Regards,
Pradeep

Thanks Much Pagadrai

Let me such and get back to you.

Pagadrai wrote:Hi Pradeep,
What I understand is that your number of 'computed columns' in input is not limited.
is this correct ?

Hi Pagadrai,

Exactly

hi Bugfree,

Ya you are correct,we can achieve that

one doubt

suppose my input

a b c d e
1 10 20 30 40 so on.....

how to achieve
a Computed(col)
1 10
1 20
1 30
1 40
So on...

other than pivot stage.

really thanks for sharing your idea,

mahadev.v wrote:Any specific reason why you don't want to use the Pivot stage? A custom Build Op stage can be used, but involves a lot of coding.

Hi Mahadev,

No reason behind that

Whats that Custom Op?

Any Idea how we can perform in Transformer.

Thanks for the reply

Hi Experts,

I have requirement


Input:

a b c
1 10 20
2 30 40

Output Required:

a Computed_col(E)
1 10
1 20
2 30
2 40

How to achieve these other than pivot stage.

Can anyone help me on this?

Thanks in advance for your reply! [/b]

Hi Kryt0n

I just want the count the no of month between two dates,how achieve these.