Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have the following data which has planned employer and actual employer for each job. I wish to create a filter pane that when I choose:
Jobid | Planned Employer | Actual employer |
1 | Direct | Direct |
2 | Direct | A |
3 | A | Direct |
4 | B | C |
5 | B | B |
6 | C | B |
7 | C | Direct |
8 | C | C |
Both fields have the same data and should be therefore merged per concatenation into a single field, for example with something like:
t: load Jobid, [Planned Employer] = [Actual Employer] as Flag,
[Planned Employer] as [Employer], 'Planned' as Source
from Source;
concatenate(t) load Jobid, [Planned Employer] = [Actual Employer] as Flag,
[Actual Employer] as [Employer], 'Actual' as Source
from Source;
and with the extra field Source you could differentiate between planned and actual.