I had fields like state_new and state_old . so my requirement was
1. showing the distinct vales combination of both state_new and state_old and want to show as single field
2.if i select either state_old or state_new i should display old(select field value ) or new(select field value ) with respective their records.
the code i had done is like this.
Maintable:
LOAD code,
project,
state_new,
state_old,
daysspent
FROM
(ooxml, embedded labels, table is Sheet1);
main_temp:
load state_new as state__temp Resident Maintable;
Concatenate
load state_old as state__temp Resident Maintable;
maintemp2:
load Distinct state__temp as state Resident main_temp;
but i got struct here how to link state field with both fields state_new and state_old in maintable . by forming assocation i can acheive my requirment based on state selection we can get both new and old assocaited records.
can any one help me this please. i had attached the data please check it if my question not clear
