Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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