Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Malanagaraj
Employee
Employee

Textbetween function

Hi All

Does using  text between and Map substring slow down the app performacne if the volume of data is High? TextBetween(MapSubString('MapTYpe', PRIMARY_ATTRIBUTE_VALUE), '/', '\')

Labels (1)
1 Reply
marcus_sommer

In general it should be performing quite fast because mapping is very fast and also string-functions don't need much processing-power. I don't remember of using textbetween(mapsubstring()) against larger data-sets but multiple and vertically/horizontally nested subfield(applymap()) are performing well in larger datasets.

Of course doing the loads without such transformations would be faster especially if the loads could be performed optimized. Maybe more relevant - are there any alternatives with a better performance? Rather not ... from a classical programming point of view the use of REGEX might be an alternatives but it will depend on a lot of circumstances and if an implementation would need some intermediate steps the possible faster string-preparation might not lead to a better overall run-time.

Beside of the above if any possible you should apply incremental approaches on larger data-sets.