Compare 2 columns in 2 table with one name

[Anonymous]

I have 2 table (MissionTable and PolicyTable)

I want a list as Priority  that contain all policy plus MissonName that are not exist in policyTable

the example is in attachment

anyone can help me?

[surendraj · Accepted solution]

Hi,

first load the Policy table.

second load the mission table.

Policy:

LOAD * INLINE [

];

Policy1:

load MissionCode,policy as MissionName

resident policy;

Concatinate(policy1)

Mission:

LOAD * INLINE [

]where NOT EXISTS(MissionCode);

Priority:

LOAD MissionName as Priority

resident mission;

drop table Policy;

drop table Policy1;

By droping these two tables,finally you have priority table.

Note:here you get missionName.you can alias it as Priority.

--Surendra

[Anonymous]

thanks bud I get not found table for priority table
I used NoConcatenate before load of priority table but it didn't work

[Anonymous]

Thanks

when I put 'Policy1' instead of 'mission' in policy table in resident part, it works

[surendraj]

Yes correct,by concatenating,you get only one table.(policy1).So need to specify policy 1 in resident.