Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which reads data from two different sources, containing details of performers appearing on a show:
| Performer | Show | Week |
|---|---|---|
| The Pebble | Cooked | 17 |
| Double H | Cooked | 17 |
| Rock Hot Jane Austen | Cooked | 17 |
| Andy Norton | Cooked | 17 |
| Broccoli Leicester | Cooked | 17 |
| Middle | Cooked | 17 |
| Muslim | Cooked | 17 |
| Performer | Show | Week |
|---|---|---|
| The Pebble | TouchUp | 17 |
| Double H | TouchUp | 17 |
| Rock Hot Jane Austen | TouchUp | 17 |
| Andy Norton | TouchUp | 17 |
| The Overgiver | TouchUp | 17 |
| Bain | TouchUp | 17 |
| Burt Apex | TouchUp | 17 |
Table1:
=sum({<Show = {'Cooked'}, Week = {'$(vWeek)'}, City = {'$(vCity)'}>}RecCounter)
Table2:
=sum({<Show = {'TouchUp'}, Week = {'$(vWeek)'}, City = {'$(vCity)'}>}RecCounter)
From this, I'm looking to produce two further tables showing performers which only appear in ONE of the two shows in one week; i.e. one table showing just the orange rows, and the other table showing just the light blue rows. Any ideas on what set expressions I should use for these two tables? I've tried using symmetric difference set operators but had no luck so far. Thanks.
See attached qvw.
Thanks, that works like a dream. Who would have thought an E could be so helpful?
( ͡° ͜ʖ ͡°)