Combine to Fields in one Qlik Sense Filter

[Rahelfw]

0

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

[Taoufiq_Zarra]

@Rahelfw  can you elaborate

[MarcoWedel]

Yes, it is:

table1:
Load Activity as [Result I need],
     [Activity Code]
Inline [
Activity,Activity Code
A,A01
B,A03
C,A05
D,B02
E,B06
,B03
,C01
,C03
,C08
,D24
,D21
,D30
,E11
,E15
,E22
];

Concatenate (table1)
Load [Activity Code] as [Result I need]
Resident table1;

Drop Field [Activity Code];