Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

Finding values of one column in another column

Hi Have table with three columns

NAME VALUE1 VALUE2
AAA 1;2;3 1;3
BBB 2;3;4 4;5
CCC 11;12;13;14;15 13;15
DDD 21;22;23;24 31;32
EEE 41;42;43;45;46;47 43;47
     
     

 

So, my goal is to know which NAMES has values from VALUE1 that also appear in VALUE2.

output

NAME VALUE1 VALUE2 flag
AAA 1;2;3 1;3 yes
BBB 2;3;4 4;5 no
CCC 11;12;13;14;15 13;15 yes
DDD 21;22;23;24 23;32 no
EEE 41;42;43;45;46;47 43;47 yes
Labels (4)
1 Solution

Accepted Solutions
Digvijay_Singh

Check this may be - 

 

source:
Load NAME,VALUE1, VALUE2, if(SubStringCount(FLAG,'NO')>=1, 'NO', 'YES') as YNFLAG
;
Load NAME,VALUE1, VALUE2, Concat(FLAG1,';') as FLAG
Group By NAME,VALUE1, VALUE2
;
Load *, If(SubStringCount(VALUE1, VALUE2_ITEMS)>=1,'YES','NO') as FLAG1
;
Load *, subfield(VALUE2,';') as VALUE2_ITEMS

inline [
NAME, VALUE1, VALUE2
AAA, 1;2;3, 1;3
BBB, 2;3;4, 4;5
CCC, 11;12;13;14;15, 13;15
DDD, 21;22;23;24, 31;32
EEE, 41;42;43;45;46;47, 43;47
]

Digvijay_Singh_0-1661020187744.png

 

View solution in original post

2 Replies
Digvijay_Singh

Check this may be - 

 

source:
Load NAME,VALUE1, VALUE2, if(SubStringCount(FLAG,'NO')>=1, 'NO', 'YES') as YNFLAG
;
Load NAME,VALUE1, VALUE2, Concat(FLAG1,';') as FLAG
Group By NAME,VALUE1, VALUE2
;
Load *, If(SubStringCount(VALUE1, VALUE2_ITEMS)>=1,'YES','NO') as FLAG1
;
Load *, subfield(VALUE2,';') as VALUE2_ITEMS

inline [
NAME, VALUE1, VALUE2
AAA, 1;2;3, 1;3
BBB, 2;3;4, 4;5
CCC, 11;12;13;14;15, 13;15
DDD, 21;22;23;24, 31;32
EEE, 41;42;43;45;46;47, 43;47
]

Digvijay_Singh_0-1661020187744.png

 

pala_jagadeesh
Contributor III
Contributor III
Author

@Digvijay_Singh ,

Thank you so much