DSXchange

Hi again :) I am not able to get a routine working.Its my first time and i have read thru all previous posts on parallel routines but haven't found a solution :( PLease help. Here are the details : The code is a very simple small function written as cpp. Have compiled using a lot of different compil...

Its done! :) Implemented by splitting th e cross ref file into 2 : all the rows wid default value for second lookup column put in second file and then pull values from the 2 datasets. One will correspond to actual value and second to default. Chk in following transformer which is the required combin...

Can u please elaborate. I too dont have access to premium content.

Do u mean use two lookup stages or only one in which u do 2 lookups : once using both keys n second time using one key and a default? How is this done? Performing 2 lookups in one lookup stage? Or am i missing somethig here?

No, i cannot use a lookup stage. the lookup is like this : first lookup based on 2 fields. If it fails then, default the second feild n do a lookup again on same file. this would mean two lookup file stages and transformers. Thats why was thinking of using a routine. Any ideas pls help...

Hi, I need to read a file, populate an array and perform a lookup using that array as part of a routine which will be called per record in a transformer. I haven't used routines before. I would like to know if it is advisable to do file operations in a routine. Also, will the entire routine be execu...