Matching values

[Anonymous]

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?

[wdchristensen]

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]

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 ?

[wdchristensen]

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/StringFunctions/Fin...

[OmarBenSalem]

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

[wdchristensen]

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

[zebhashmi]

No - what is required output from the data 

[Anonymous]

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]

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

yes?

[Anonymous]

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'