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

How do i filter or search variable possiblity

CSV data 1.JPG

Good day..

I have a Massive CSV file ( 120gb) from a database where the file is obviously no longer normalised.. I'm trying to build a filter or even just search a certain way.. if you look at the data.. there will be a . for option followed by a | for selection thereafter. now in those selections there can be a single number, or 2 3 4 5 how ever many the data gives..

I want to be able to search or filter for instance ALL subsetinv.normal|"x,x,x" meaning all subsetinv normal with 3 number selections.

how would one do that filter?

1 Reply
dwforest
Specialist II
Specialist II

Not sure how/where you want to put this, but FindOneOf (https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/StringFunctions/Find...) could be used:

FindOneOf(BetLog.Option,'subsetinv.normal) and FindOneOf(BetLogOption,',',2)

However, best solution if loading this data into Qlik would be to divide that field into discrete fields, then standard filters/set expressions would be more direct.

see https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/splitting-a-field.htm