Grouping Data

[#1]

Hi , 

I need to implement the below scenario in qlikview. Can anyone please help ? 

from the first table,  I need to group the records based on client count column. 

then if the sourcesystem='Bermuda' then the programtype and markedcode values should overide based on the Sourcessystem=US records 

There should not be any change to the US sourcesystem records . 

I have given the before and after sample data below .

Can anyone please help me in this ?

Thanks

[Gysbert_Wassenaar]

Try something like below. The inline load is just an example. You can replace it with a from ...somewhere.... to load the date from a file or database.

Before:

LOAD *, RowNo() as rowid INLINE [

    sourcesystem, client count, marketed, program_type, premium

    US, A, N, LS, 100

    US, B, N, GC, 200

    Bermuda, A, Y, NA, 100

    Bermuda, A, Y, NA, 100

    US, B, N, GC, 200

    Bermuda, B, Y, NA, 100

];

After:

load rowid, sourcesystem, [client count], premium

Resident Before;

join

load distinct [client count], marketed, program_type

resident Before where sourcesystem = 'US';

drop table Before;