Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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++
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);
it seems to work but not perfectly
@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).
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
Create a composite field for both the tables and use exists() similarly.
Load Machine&App as KEY_T1...
Load Machine&App as KEY_T2...
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
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