Discussion board where members can get started with Qlik Sense.
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?
Can you provide a little more detail (an example would help)? Are you trying to join two table on a "LIKE" condition?
from tbl_1, tbl_2
where tbl_1.digit like '%' & tbl_2.digit & '%'
OR charindex(tbl_2.digit, tbl_1.digit) >= 1
I have one table and in this table I have a column ID. IDs are 12 digit numbers.
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 ?
if(FindOneOf(sourceString, findString, 1) >= 1, 'something','other')
No - what is required output from the data
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 ?
so they all are 8 digits long but non of them are same
I have these 2 IDs
Second ID has 11 same digits.There is only one different digit so I want to have description as 'something'