DSXchange

Hi Experts,

we have a requirement to perform similar transformation on most of the incoming fields.

i.e. If IsNull(Lnk.col1) the SetNull() else StringToDate(Lnk.col1,"%yyyy%ddd")


as there are more than one field need to have similar derivation in multiple jobs. Just wanted to explore is there a simpler way to convert this into a function and pass Lnk.col1 as parameter.

We are exploring to convert it into routine but writing this code in C++ is bit tedious.

Please Advice!

Appreciate your time.

This will not directly answer your question, however...

Are you aware of the derivation substitution feature? You can, for instance, select multiple columns (dozens or hundreds), right-click, and apply the same derivation to all selected columns in a single step.

Hi ,

Thanks for your response. I am aware of derivation substitution currently we are using same mechanism but it would simplify the derivation if we could pass just the <field> as an argument and would be easy to read.

Similar to NullToEmpty function.

I have tried creating a custom transform but in derivation part StringToDate function is not recognised.

It says variable 'StringToDate' not defined.

Would appreciate your help!

StringToDate is a parallel function. You need to stick with Server functions in the transform, for example IConv/OConv... but then you could only leverage it in a Server Shared Container or a Server job proper.

Unless I'm not understanding what you mean by 'transform'.

Hi Chulett,

Thanks, this helps , Please correct me if I am wrong transform can only be written with help of server functions and we cannot leverage it, with parallel jobs .

Apart from Parallel routine are there any other option to achieve this.

Would appreciate any pointers/clues .

Thanks In Advance!

The only solution to this to generate a parallel routine.

Only? No.