Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following problem:
I have 2 tables:
First
Store | User |
---|---|
100 | Tom |
115 | Tom |
185 | Tom |
*** | Paul |
Second
Store |
---|
100 |
108 |
109 |
115 |
118 |
119 |
130 |
170 |
185 |
User "Tom" have the access for Store 100, 115, 185.
User "Pual" have the access for alle Stores where listed in the second table.
So in the End i need a table that looks like this:
Store | User |
---|---|
100 | Tom |
115 | Tom |
185 | Tom |
100 | Paul |
108 | Paul |
109 | Paul |
115 | Paul |
118 | Paul |
119 | Paul |
130 | Paul |
170 | Paul |
185 | Paul |
I need something like this:
if(Store='***', 'take all Stores from Second Table) as Store
Any ideas??
Regards
Chris
See attached qvw
Thanks for your quick answer!
It works great!