?

[xyz1]

.

[ahaahaaha]

Hi Agrim,

As variant, you can use Set Analisys expression to work similarly to the island of data. In attached file I gave an example of selecting only the same records in fields [Assetname] and [Item] (Table 3) and the same records selection with the state of field Statename as 'Non-active' (Table 4).

Similar to this approach, you can make the other selections you need.

Regards,

Andrey

[vinieme12 · Accepted solution]

this

map_report:

Mapping LOAD upper(Assetname) as Assetname,

  'Exists in Report'

FROM

(biff, embedded labels, table is report$);

map_Feuil1:

Mapping LOAD

    upper(Item) as ITEM,

    'Exists in Feuil1'

FROM

(biff, embedded labels, table is Feuil1$);

Tab_Feuil1:

LOAD Catégorie,

    Item,

    [Date d'installation],

    ApplyMap('map_report',upper(Item),'Not Exist in Report') as ReportExistsFlag

FROM

(biff, embedded labels, table is Feuil1$);

LOAD Assetname,

    Statename,

    Lastchanged,

          ApplyMap('map_Feuil1',upper(Assetname),'Not Exist in Feuil1') as Feuil1ExistsFlag

FROM

(biff, embedded labels, table is report$);