DSXchange

Hi,
I tried creating a stage variable and concatenating '/'. But still I am getting the error message, "Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful".

But the problem is there is no / between the dates in the Input.
It is just MMDDYY. That is the reason i feel it is causing the error.

Hi,
the format is mmddyy.
The error I am getting is "Attempting to convert string value "12/31/79" to Date is Unsuccessful".

Hi,
my input is a string (123179) which needs to be converted to date type.
I tried using iconv and oconv but am still getting date conversion error.
Can someone help me with this..
Thanks,
Krishna.

Can someone copy and paste the message for me..
I am not able to see the complete message..

Hi,
I am implementing this logic in two transformers, all the stage variables in one transformer and the source columns in one trn stage but,
the logic is not fetching me the results. I am able to retreive the next value of column B, but not the set logic until there is a change in B.

Hey,
I tried this logic..
but it did not work...

The data type of b is Integer.
The column b need not be generated.
only column d has to be generated whise datatype is also integer.

The column D values have to be populated from column b. The second value of b should be the first value of column d. If the value of b is repeating, the same value should be generated in b till we get the next change. a b c d 1 10 2 11 1 11 2 12 1 11 2 12 1 11 2 12 1 12 2 15 1 15 2 NULL For Ex: seco...

I have a scenario like this.. The column d should be generated based on the logic below. a b c d 1 10 2 11 1 11 2 12 1 11 2 12 1 11 2 12 1 12 2 15 1 15 2 NULL a and c are my keys which will have same value. The value of the second column in b should be populated as first value of d. The next change ...

Hey loveojha2 ! Thanks, it worked.

I have 2 columns A & b.
The column A contains 1,2,3. The Output should be like below:

A B
1 2
2 3
3 NULL

In the same column B, I should increment all the values by One, but the last value should be NULL.

Any idea Guys?

What is the exact error message that you are getting?