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: 
Anonymous
Not applicable

Matching values

Hello,

I have one question. I have 12 digit numbers. I want to create a new field for the numbers who have  more than 8 digits the same. Is this possible in qlik sense?

13 Replies
wdchristensen
Specialist
Specialist

Can you provide a little more detail (an example would help)? Are you trying to join two table on a "LIKE" condition?

sql

Select *

from tbl_1, tbl_2

where tbl_1.digit like '%' & tbl_2.digit & '%'

OR charindex(tbl_2.digit, tbl_1.digit) >= 1

Anonymous
Not applicable
Author

I have one table and in this table I have a column ID. IDs are 12 digit numbers.

For example:

125169875265

124167875265

125164875465

125452752645

I want to create another field. I want to look up the IDs where  more than 8 digits are same( in all of these ID's)  .

if (more than 8 digits are same, 'something','other') --- I want something like this

Is it clear ?

OmarBenSalem

if(len(trim(YourField))>=8,'Sthing','other')

wdchristensen
Specialist
Specialist

if(FindOneOf(sourceString, findString, 1) >= 1, 'something','other')

zebhashmi
Specialist
Specialist

No - what is required output from the data 

Anonymous
Not applicable
Author

In sourceString I write the IDs and what should I write in find string?? numbers ? ( but I want any number which has more than 8 digit the same) . Or should I write 8 ?

Sorry for these questions but i didn't understand this formula well. what does >=1 means in this formula ?

zebhashmi
Specialist
Specialist

so they all are 8 digits long but non of them are same

yes?

Anonymous
Not applicable
Author

For example,

I have these 2 IDs

145687432146 

145647432146 

Second ID has 11 same digits.There is only one different digit so I want to have description as 'something'

else 'other'