expression for the following scenario

[#1]

I need to get the same supplier group for the common Global supplier id

Gloabal supplier id  , ncr,         scar,      partnumber ,           supplier group

ew-000891              234            145          ahaas652            CMDS

ew-000891               12                3          fa                         -

ew-000891                 -              -                -                       -

Please find screen shot.

For that same global supplier id i need to CMDS as supplier group for the remaining two records

[#2]

Whilst it may be possible to work around this problem in the UI objects, I agree with some of the earlier posts that this should be fixed in the load script. Using the extra functions on the UI will likely impact performance and when you reach a critical volume of data this may make you app unusable.

[qlikpahadi07]

Hi Sreddy,

I think maxgrohad provided you the solution ? isit ?