Discussion Board for collaboration on QlikView Scripting.
Someone do you know some function that get the last stream that have for example the word 'CM' to the finally
I need Just the records that have in finally of the stream the word 'CM' please JUST only in the FINALLY the word 'CM'
in the last example I need just:
thanks can you help me!!!
Go to Solution.
I was looking for and the solution is:
where WildMatch(item, '*CM')
in this way I will have all records in the final have the word 'CM'
thanks very much for your help.
Use Index function
LOAD * INLINE [
] Where Index(items,'CM');
And you get output as
Another one is
items as [CM items]
thanks a lot but the index in this way just get all records that have "CM" in any part of the stream that I need is all records to the finally it have 'CM' but any way I find the solution it's too easy but anand chouhan thanks for your help!!!!
If CM is always the last two letters, then you can use the conditional:
Hope this helps!
this way is correct also thanks jerem1234