Hi,
We have requirement where in we get records in two different structures and from that by comparing 2 structures based on conditions needs to get records from both stuctures.
Record had structures A and B.
Structure A
Control;Groupes Code;Groupes Name;Groupes type;Active
0;02AIS;Groupt d'Achats de l'Aisne / C.H. St Quentin 02;;0
0;CACIC;CACIC;GPO;0
0;12ROD;Groupt d'Achats de l'Aveyron / C.H. Rodez 12;;1
0;15AUR;Groupt d'Achats Dépt du Cantal / C.H. AURILLAC 15;;0
0;18AIN;Groupt d'Achats Psy / C.H.S. Bourges 18;;1
0;CORSE;Groupt d'Achats Départemental / C.H. Ajaccio 20;;1
0;EURE;Groupt d'Achats de l'Eure / C.H. Evreux 27;;1
0;MIDI;Groupt d'Achats Interdépartemental /CH Lannemezan;;1
sTRUCTURE B HAS
Control;GPO Name;Member Number;Member Status ;Membership Start Date; Membership End Date
0;CAHP;33000002;1;19800101;
0;CACIC;33000011;1;19800101;
0;CAHP;33000013;1;19800101;
0;CAHP;33000014;1;19800101;
0,CAP,3212131,198001012
How can I achive this in UDF.