I have 2 Fields and I need to combine them in one field. Is it possible to get this result in Qlik Sense?
Activity | Activity Code | Result I need | |
A | A01 | A | |
B | A03 | A01 | |
C | A05 | A03 | |
D | B02 | A05 | |
E | B06 | B | |
B03 | B02 | ||
C01 | B06 | ||
C03 | B03 | ||
C08 | C | ||
D24 | C01 | ||
D21 | C03 | ||
D30 | C08 | ||
E11 | D | ||
E15 | D24 | ||
E22 | D21 | ||
D30 | |||
E | |||
E11 | |||
E15 | |||
E22 |