comparison two table

[Obs_vdf_paris]

Hello pleaseif you can help me

I have two table: table A of reference and table B normal which continues the chain of character

1- I want to display the elements which exist in the reference table A but which do not exist in the table B

2- I want to display the elements which exist in the reference table A  and exist in the table B 

Table A:

Adobe_Adobe-Reader
Adobe-AcrobatPr-X86
Adobe-ActiveX
Full_32.0.0.192
PAPI_32.0.0.207
Microsoft_C++2013-x64

Table B:

Adobe-AcrobatPr-X86

Full_32.0.0.192
PAPI_32.0.0.207

Oracle_Java_7

C++

[tresesco]

Like this?

TableA:
Load * Inline [
FieldA
Adobe_Adobe-Reader
Adobe-AcrobatPr-X86
Adobe-ActiveX
Full_32.0.0.192
PAPI_32.0.0.207
Microsoft_C++2013-x64
];
 
TableB:
Load * Inline [
FieldB
Adobe-AcrobatPr-X86
Full_32.0.0.192
PAPI_32.0.0.207
Oracle_Java_7
C++];

InAButB:
Load FieldA as InAButB Resident TableA where not Exists(FieldB, FieldA); 

InBoth:
Load FieldA as InBoth Resident TableA where Exists(FieldB, FieldA); 

[Obs_vdf_paris]

it seems to work but not perfectly

[tresesco]

---

@Obs_vdf_paris wrote:

it seems to work but not perfectly

---

Don't you think this statement actually doesn't help understand what is working and what is not? Try to explain a bit so that we can work to make it work for you (may be perfectly). 

[Obs_vdf_paris]

because on the table B I have the machines associated a lot of machine;

when I take it without machine it works but with machine it does not work;

the goal is to find on each machine the elements which are on the tableA (reference) and those which are not

Table B: 

Machine        app

     M1                    Adobe_Adobe-Reader
     M1                  Adobe-AcrobatPr-X86
     M1                  Adobe-ActiveX
     M1                   Full_32.0.0.192
      M1                PAPI_32.0.0.207
      M1               Microsoft_C++2013-x64

    M2                    Adobe_Adobe-Reader
     M2                  Adobe-AcrobatPr-X86
     M2                  Adobe-ActiveX

 M3               Adobe-AcrobatPr-X86

M3                    Full_32.0.0.192
 M4                  PAPI_32.0.0.207

M4                 Oracle_Java_7

M4                Adobe-AcrobatPr-X86
 M4                  Adobe-ActiveX
 M4                   Full_32.0.0.192

[tresesco]

Create a composite field for both the tables and use exists() similarly.

Load Machine&App as KEY_T1...

Load Machine&App as KEY_T2...

[Obs_vdf_paris]

I DO A COMPOSITE CHAMPS IN TABLE InAButB: AND  InBoth:  but d'ont work 

in table in A but in B is the table is A reference but nor in B withe machine 

[Obs_vdf_paris]

the problem is that on table B I have machine machine 1 with missing compared to the reference table A but the whole table has all the APPs

I'm trying to find out what's missing from M1 compared to A what is missing in M2 compared to A ... ect

Table B: 

Machine        app

     M1                    Adobe_Adobe-Reader
     M1                  Adobe-AcrobatPr-X86
     M1                  Adobe-ActiveX
     M1                   Full_32.0.0.192
      M1                PAPI_32.0.0.207
      M1               Microsoft_C++2013-x64

    M2                    Adobe_Adobe-Reader
     M2                  Adobe-AcrobatPr-X86
     M2                  Adobe-ActiveX

 M3               Adobe-AcrobatPr-X86

M3                    Full_32.0.0.192
 M4                  PAPI_32.0.0.207

M4                 Oracle_Java_7

M4                Adobe-AcrobatPr-X86
 M4                  Adobe-ActiveX
 M4                   Full_32.0.0.192

Table A :

app

           Adobe_Adobe-Reader
            Adobe-AcrobatPr-X86
                 Adobe-ActiveX
                   Full_32.0.0.192
                PAPI_32.0.0.207
               Microsoft_C++2013-x64

                   Oracle_Java_7