Scripiting and logic issue

[Anonymous]

Hi .

I had issue . i had a metric.old_subsystem and metric.new_substem  in the table .  i want the combination of  both in one list box like union and i want distanct values .

so what i had done

Load old_subsystem as subsystem resident table

Concatenate

Load new_subsystem as subsystem resident table .

By this i got distinct values and ccombination  of that in list box .

My requirment 2 is

If i select anything from newly derivered substem  it should display both  old and new selected value .

logic old(seleted value )or new (selected value ).

Can any one  help to achieve this .

Find the sample data in attached file .

Thanks in advance !

[jonathandienst]

If you join with the two subsystems, like this:

Subsystems:

LOAD old_subsystem, old_subsystem as subsystem

FROM ...

Join (Subsystems)

LOAD new_subsystem, new_subsystem as subsystem

FROM ...

The full outer join will load all records. This associates the subsystem values with you data model. Selecting a subsystem will be the same as selecting the new and/or old value(s).