Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

split and compare fields

Hi,


In a table,I have two fields A and B. I have to retrieve those rows where A<>B. The problem isA could be '12|14|15' and B could be '12|15|14'. So, they are actually same , only that the order of numbers is different. How do I retrieve rows where the fields are really not equal ,like'30|31|14' and '31|30|15', or '22|23' and '22' ?

Thanks,

Anju

1 Solution

Accepted Solutions
MayilVahanan

HI

May be try like this

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

7 Replies
MayilVahanan

Hi

May be its give solution for you, but not sure..

Split the column by using SubField() function.

Then by use order by concatenate it by using concat() function, after that check it.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

can you provide some sample scripts please?

MayilVahanan

HI

May be try like this

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank You!

This would solve my problem.

Not applicable
Author

Hi Mayil,

After I have been able to find unequal strings.. and I have , say 2 fields A and B,

where A is say '12|13|15' and B is '15|12|14' can I have have 2 more fields like 'In A not in B '='13' and 'In B not in A'='14'.

Thanks,

Anju

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

I hope the attachment will help you

Not applicable
Author

Thank you, Celambarasan!