Need Help

[dhanu_today]

Hi Everyone,

If the ‘STATUS’ contains 1 or 5 then we have consider SECONDARY ID in the new field say Final-ID in the remaining cases we have to consider the PRIMARY ID.

Based on the derived Final-ID we have to map the ID (from DATA2 from attachment) and get the relevant fields like CODE,AOD,PR_CODE, Identification. Then based on Identification we have get the AREA, AREA CODE.

The same has been attached here with.

  Thanks,

  Dhanu

[dhanu_today]

Any hint from anyone...

[venkatg6759]

Check the attachment

[dhanu_today]

Thanks Venkat.It seems working.Onething if in case the final id(which contains secondary id case) not available in the ID(Data2) how can i show Primary Id or blank for that.

I hope you understand.

Thanks,

Dhanu

[venkatg6759]

Can you pick an ID and explain me .That will help to understand better

[dhanu_today]

Lets say am removing the ID(data2) 40001 then how can i show in this case primary id related data or blank.

Thanks,

Dhanu

[dhanu_today]

The application also not working if am selecting the STATUS 5.

Thanks,

Dhanu

[venkatg6759]

go to the presentation AOD  and uncheck omit rows where Field is NULL

[dhanu_today]

We are getting the data except 1 and 5.Its because of we have consider ID as Secondary ID.

How we have to get the 1 and 5 data also.

Thanks,

Dhanu

[venkatg6759]

we don't have data for 1 and 5 , since we are joining based on secondary ID

example

if you pick status 1

secondary ID -10001

In Data 2 sheet that ID doesn't exist. so the associations are also blank for that .