Date conversion in PX

[praj]

Hi,

How do we handle date conversions in PX?

For server jobs, we can use iconv and oconv but in PX theres no such option. So then how to handle dates which are not in standard formats?
For ex: if you have a date like 24-dec-2003, there is no way but to have a file with dec->12 mapping and using this file as lookup.

ne help regarding same!!!!
TIA,
Praj

[Teej]

For ex: if you have a date like 24-dec-2003, there is no way but to have a file with dec->12 mapping and using this file as lookup.

Build a large if then statement within the stage variables within the Transform stage that read in the the month string and convert them to numbers. Then do a StringToTimeStamp().

-T.J.

[praj]

Thanx Teej,

That is what i have done but dont u think it will make process lil slow.

I thought of writing one single server job, in between my parallel jobs, for these kind of conversions, but then one will miss out the crux of PX.

Regards,
Praj

[Teej]

Thanx Teej,

That is what i have done but dont u think it will make process lil slow.

I thought of writing one single server job, in between my parallel jobs, for these kind of conversions, but then one will miss out the crux of PX.

Regards,
Praj

Do what I would do: Implement all possible solutions, and run a test of 1 million rows with all possible solutions, and see how the performance holds up.

I found that the performance held up pretty well for the if/then statement within PX. Difference in time processed was minimal compared to using a Buildop. In fact, Transform solution sometimes performs better than the buildop solution.

-T.J.