I have two property Arrays LogdataReg and DisplayReg.
DisplayReg may or may not have the same records as LogDataReg.
How do I subtract DisplayReg from LogDataReg to get the Missing Entries that are in LogDataReg but not in DisplayReg?
I am only interested in the first field "REG" of each record for use in the comparison. In the sample setup the Missing Entries are "MISSING1" and "MISSING2".
I have been trawling through Table of Contents in the Alpha Five Documentation, but cannot find anything that might do it.
DisplayReg may or may not have the same records as LogDataReg.
How do I subtract DisplayReg from LogDataReg to get the Missing Entries that are in LogDataReg but not in DisplayReg?
I am only interested in the first field "REG" of each record for use in the comparison. In the sample setup the Missing Entries are "MISSING1" and "MISSING2".
I have been trawling through Table of Contents in the Alpha Five Documentation, but cannot find anything that might do it.
'setup test data
dim shared DisplayData as c = <<%a%
4X-EDM|4X-EDM||ISRAEL|01|02/10/2019|{PAGANHILL SBS}
9H-QAC|EI-FZS||MALTA|01|19/05/2017|{PAGANHILL SBS}
A7-ANA|A7-ANA||QATAR|01|02/10/2019|{PAGANHILL SBS}
D-ABYI|D-ABYI||GERMANY|01|16/03/2014|{PAGANHILL SBS}
EC-MII|EC-MII||SPAIN|01|02/10/2019|{PAGANHILL SBS}
EI-EKX|EI-EKX||IRELAND||03/11/2016|{PAGANHILL SBS}
EI-LRB|EI-LRB||IRELAND|01|02/10/2019|{PAGANHILL SBS}
G-BDZD|G-BDZD||UK|01|02/10/2019|{PAGANHILL SBS}
G-BOYF|G-BOYF||UK|01|02/10/2019|{PAGANHILL SBS}
G-IZZT|G-IZZT||UK|01|07/07/2018|KEMBLE
G-NEOV|G-NEOV||UK|01|02/10/2019|{PAGANHILL SBS}
G-SUEI|G-SUEI||UK|01|29/08/2019|STAVERTON
G-XWBB|G-XWBB||UK|01|02/10/2019|{PAGANHILL SBS}
HB-JCT|HB-JCT||SWITZERLAND|01|02/10/2019|{PAGANHILL SBS}
N1F|N1F||USA|01|02/10/2019|{PAGANHILL SBS}
N536LA|N536LA||COLOMBIA|01|02/10/2019|{PAGANHILL SBS}
TC-JYM|TC-JYM||TURKEY|01|02/10/2019|{PAGANHILL SBS}
%a%
dim shared LogData as c = <<%a%
MISSING1|MISSING1|||02/10/2019|01|{PAGANHILL SBS}
MISSING2|MISSING2|||02/10/2019|01|{PAGANHILL SBS}
4X-EDM|4X-EDM|||02/10/2019|01|{PAGANHILL SBS}
D-ABYI|D-ABYI|||02/10/2019|01|{PAGANHILL SBS}
A7-ANA|A7-ANA|||02/10/2019|01|{PAGANHILL SBS}
G-NEOV|G-NEOV|||02/10/2019|01|{PAGANHILL SBS}
N536LA|N536LA|||02/10/2019|01|{PAGANHILL SBS}
TC-JYM|TC-JYM|||02/10/2019|01|{PAGANHILL SBS}
EC-MII|EC-MII|||02/10/2019|01|{PAGANHILL SBS}
9H-QAC|9H-QAC|||02/10/2019|01|{PAGANHILL SBS}
G-BDZD|G-BDZD|||02/10/2019|01|{PAGANHILL SBS}
EI-LRB|EI-LRB|||02/10/2019|01|{PAGANHILL SBS}
EI-EKX|EI-EKX|||02/10/2019|01|{PAGANHILL SBS}
G-BOYF|G-BOYF|||02/10/2019|01|{PAGANHILL SBS}
G-IZZT|G-IZZT|||02/10/2019|01|{PAGANHILL SBS}
G-SUEI|G-SUEI|||02/10/2019|01|{PAGANHILL SBS}
N1F|N1F|||02/10/2019|01|{PAGANHILL SBS}
G-XWBB|G-XWBB|||02/10/2019|01|{PAGANHILL SBS}
HB-JCT|HB-JCT|||02/10/2019|01|{PAGANHILL SBS}
%a%
dd = *count(DisplayData)
ld = *count(LogData)
trace.clear()
dim shared DisplayReg[dd] as p
dim shared LogdataReg[ld] as p
DisplayReg.initialize_properties("reg|as|code|Country|H|When|where",DisplayData)
LogDataReg.initialize_properties("reg|as|code|Country|H|When|where",LogData)
dim shared DisplayData as c = <<%a%
4X-EDM|4X-EDM||ISRAEL|01|02/10/2019|{PAGANHILL SBS}
9H-QAC|EI-FZS||MALTA|01|19/05/2017|{PAGANHILL SBS}
A7-ANA|A7-ANA||QATAR|01|02/10/2019|{PAGANHILL SBS}
D-ABYI|D-ABYI||GERMANY|01|16/03/2014|{PAGANHILL SBS}
EC-MII|EC-MII||SPAIN|01|02/10/2019|{PAGANHILL SBS}
EI-EKX|EI-EKX||IRELAND||03/11/2016|{PAGANHILL SBS}
EI-LRB|EI-LRB||IRELAND|01|02/10/2019|{PAGANHILL SBS}
G-BDZD|G-BDZD||UK|01|02/10/2019|{PAGANHILL SBS}
G-BOYF|G-BOYF||UK|01|02/10/2019|{PAGANHILL SBS}
G-IZZT|G-IZZT||UK|01|07/07/2018|KEMBLE
G-NEOV|G-NEOV||UK|01|02/10/2019|{PAGANHILL SBS}
G-SUEI|G-SUEI||UK|01|29/08/2019|STAVERTON
G-XWBB|G-XWBB||UK|01|02/10/2019|{PAGANHILL SBS}
HB-JCT|HB-JCT||SWITZERLAND|01|02/10/2019|{PAGANHILL SBS}
N1F|N1F||USA|01|02/10/2019|{PAGANHILL SBS}
N536LA|N536LA||COLOMBIA|01|02/10/2019|{PAGANHILL SBS}
TC-JYM|TC-JYM||TURKEY|01|02/10/2019|{PAGANHILL SBS}
%a%
dim shared LogData as c = <<%a%
MISSING1|MISSING1|||02/10/2019|01|{PAGANHILL SBS}
MISSING2|MISSING2|||02/10/2019|01|{PAGANHILL SBS}
4X-EDM|4X-EDM|||02/10/2019|01|{PAGANHILL SBS}
D-ABYI|D-ABYI|||02/10/2019|01|{PAGANHILL SBS}
A7-ANA|A7-ANA|||02/10/2019|01|{PAGANHILL SBS}
G-NEOV|G-NEOV|||02/10/2019|01|{PAGANHILL SBS}
N536LA|N536LA|||02/10/2019|01|{PAGANHILL SBS}
TC-JYM|TC-JYM|||02/10/2019|01|{PAGANHILL SBS}
EC-MII|EC-MII|||02/10/2019|01|{PAGANHILL SBS}
9H-QAC|9H-QAC|||02/10/2019|01|{PAGANHILL SBS}
G-BDZD|G-BDZD|||02/10/2019|01|{PAGANHILL SBS}
EI-LRB|EI-LRB|||02/10/2019|01|{PAGANHILL SBS}
EI-EKX|EI-EKX|||02/10/2019|01|{PAGANHILL SBS}
G-BOYF|G-BOYF|||02/10/2019|01|{PAGANHILL SBS}
G-IZZT|G-IZZT|||02/10/2019|01|{PAGANHILL SBS}
G-SUEI|G-SUEI|||02/10/2019|01|{PAGANHILL SBS}
N1F|N1F|||02/10/2019|01|{PAGANHILL SBS}
G-XWBB|G-XWBB|||02/10/2019|01|{PAGANHILL SBS}
HB-JCT|HB-JCT|||02/10/2019|01|{PAGANHILL SBS}
%a%
dd = *count(DisplayData)
ld = *count(LogData)
trace.clear()
dim shared DisplayReg[dd] as p
dim shared LogdataReg[ld] as p
DisplayReg.initialize_properties("reg|as|code|Country|H|When|where",DisplayData)
LogDataReg.initialize_properties("reg|as|code|Country|H|When|where",LogData)
Comment