Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
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$);
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
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$);