Lookup in transformation not fetching all records

[Former Member]

Hi Experts,

In the routine of the transformation of a DSO (say DSO1), i have written a look-up on other DSO (say DSO2) to fetch records. I have used all the key fields of DSO2 in the Select statement, Still the look-up is not fetching all the records in DSO1. There is difference in the aggregated value of the Key Figure of both the DSOs. Please suggest, how can i remove this error.

Thanks,

Tanushree

[Former Member · Accepted solution]

hi tanushree,

The code which yu have written in the field routine for lookup is not fetching the data. you can debug the field routine code in the simulation mode of execution of DTP by keeping a break point after the transformation.

you can test the routine with out actually loading the data..

double click rule where you have routine and in the below you have option called test routine.

here you can pass input parameters..

i hope it will give you an idea.

Regards

Chandoo7

[Former Member]

Hi Tanushree,

Please share your code so that I will know where is main problem is..

Avenai

[Former Member]

Hi Tanushree,

Can you clarify the following points :

1) What exactly are you trying to look up i.e a key figure or a characteristic ?

2) And also share your code so that we can troubleshoot your issue .

Kind Regards,

Ashutosh Singh