Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need some help, I have a table with teams and their associated assets as shown in the table below
Team | Assets |
A | books |
B | books |
C | books |
A | Radio |
B | Radio |
C | Radio |
D | Radio |
So from the table above I can see that Team A,B,C have books however Team D does not. We can identify that a Team D exists because Team D has a radio.
Does anyone know what syntax I can write to identify that team D does not own the asset 'books'
Thanks,
Isaac
Where exactly are you looking to show this information? and do you just need to display the name of the Team which doesn't have all the assets or do you need to display the name of the Asset as well?
Thank you for your help.
Im hoping to create a table which looks like:
Assets | Team that does not have Asset |
Books | D |
If source having like below including your sample data, Then what is the expected output?
Team, Assets
D, books
E, books
F, Radio