DSXchange

Hi,
Can anyone help me to resolve this?
I'm receiving the timestamp value. It is in format of 24hrs. I need to convert to 12 hrs format.

Eg:Input: 2005-01-01 00:00:00.000000
Output:2005-01-01 12:00:00 AM





Thanks,

Thanks Ravi

Hi, I want all my output fields should be Right aligned. Eg 1: If my input field: Col1, data type: Char(4), field value:+1 My output should be: +1 (2 leading spaces then field value) Eg 2: If my input field: Col2, data type: integer(4), field value:10 My output should be:0010 (2 leading zeros then f...

Then you missed something. Tell us exactly what you did to correct this - how you made sure the output field was null at the right time and what exact properties you set for that field. Before funneling, in both the inputs for the particular column 1. Set the field as nullable 2. In Extended proert...

chulett wrote:

ajithaselvan wrote:It can be nullable. But it can not be representated as string.

Actually, everything in a file is a string so it can. Set it to NULL and then edit the column so the 'null value' property is the appropriate number of spaces.

Hi Craig,
It didn't work. populating zero.

Regards,

I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve. The answer is simple - it cannot be done. Get a new requirement... for example, is the field nullable? Can it be represented as a string? It can be nullable. But it can not be repres...

Ajitha S - please don't post in all capital letters, it is considered SHOUTING. I corrected your post Subject for you, so more of just an FYI. Thanks. Sure craig. This will not be repeated. Regarding my query, I'm funneling 2 inputs of same columns. column(col3) from input 1 throwing a value. colum...

No. printing zero in the output

Thanks

Hi,

I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.

Thanks,

Thanks jweir.
Can you please more specific?


Thanks & Regards

In the output, REC_TYPE 'T' is the hardcoded value. Yes.2 input rows has to be merged into single row.



Thanks & Regards

Hi chulett,
What would be the correct ans if the data type is date?





Thanks & Regards,

Hi,
Kindly help me to solve this in parallel job.

Input:
REC_TYPE,REC_COUNT, REC_SUM
C,3,1000
D,5,1500

Output:
REC_TYPE,C_REC_COUNT,C_REC_SUM,D_REC_COUNT,D_REC_SUM
T, 3, 1000, 5,1500


Thanks & Regards

Thanks Murthy

Hi,
Pls let me know what is function to be used to get
only month & year from date. Format is below

Input: YYYY-MM-DD
Output: MM-YY



Thanks & Regards,