Skip to Content

Fetch similar Records

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

  • In the "sTRUCTURE A" filter has to be set on "Groupe Type" column with value “GPO” in order to find the true GPO's.
  • From above file take the GPO names from "Groupes Code" column.

  • Take those Groupes names and go the sTRUCTURE B file and filter on column “GPO name” with the “Groupes code” found in the “Groupes” file.
  • In the STRUCTURE B file, we can find the hierarchy node of the GPO filtering on the column “Member Status” with the value "3" which means "hierarchy node". The GPO number can be found in column “Member number”.

How can I achive this in UDF.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers