Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Rahelfw
Contributor
Contributor

Combine to Fields in one Qlik Sense Filter

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
Labels (3)
2 Replies
Taoufiq_Zarra

@Rahelfw  can you elaborate

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
MarcoWedel

Yes, it is:

MarcoWedel_0-1672348192582.png

 

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];