Hi,
I have the following data:
[Mappings]: *THIS TABLE SHOWS EVERY ID THAT HAS A TEAM MAPPING*
LOAD
[ID],
[TEAM],
from [MAPPING TABLE]
[Table1]
NoConcatenate
LOAD
"Official ID" as [People ID]
FROM [SHEET 1]
[ID has link]:
NoConcatenate
LOAD
[ID] as [Linked ID]
resident [Mappings];
Concatenate ([Mappings])
LOAD
[People ID] as [ID],
'No Team' as [TEAM],
'Unmapped ID' as [Responsibility]
resident [Table1]
where not exists ([Linked ID],[People ID]);
Drop table [ID has link];
Drop table [Table1];
LOAD *THIS LOAD PULLS EVERY ID IN REGARDLESS OF A MAPPING AND TIES MORE INFO LIKE COUNTRY AND ID CODE ASSOCIATING TO THE MAPPING TABLE WITH [ID]*
[Official ID] as [ID],
[ID CODE],
[COUNTRY]
FROM [TABLE 2]
THE QUESTION: every ID will be aligned to a unique [ID CODE] and multiple [ID] can belong to a [ID CODE]....i want to add another tagging similar to the above but for [ID CODE] to essentially see the [ID CODE] does not appear in the MAPPING TABLE....once the [ID] field is associated.
i keep getting a synthetic key....if someone could help that would be great!
