topic Re: Function for strem !!! in QlikView

Function for strem !!!

Tue, 15 Jul 2014 17:31:04 GMT

Hi everyone:

Someone do you know some function that get the last stream that have for example the word 'CM' to the finally

for example:

items:

123456CM

a12d13x1x1CM

1234567810

wert12345678

CM 123456456

a1d3f5g6h6CM

aw-CM

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:

123456CM

a12d13x1x1CM

a1d3f5g6h6CM

aw-CM

thanks can you help me!!!

Regards!!!

Re: Function for strem !!!

its_anandrjs — Tue, 15 Jul 2014 17:38:08 GMT

Use Index function

Ex:-

Tab1:

LOAD * INLINE [

items

123456CM

a12d13x1x1CM

1234567810

wert12345678

CM 123456456

a1d3f5g6h6CM

aw-CM

] Where Index(items,'CM');

And you get output as

123456CM

a12d13x1x1CM

a1d3f5g6h6CM

aw-CM

Re: Function for strem !!!

its_anandrjs — Tue, 15 Jul 2014 17:40:52 GMT

Another one is

Tab1:

LOAD * INLINE [

items

123456CM

a12d13x1x1CM

1234567810

wert12345678

CM 123456456

a1d3f5g6h6CM

aw-CM

];

NewTable:

LOAD

items,

items as [CM items]

Resident Tab1

Where Index(items,'CM');

Re: Function for strem !!!

Tue, 15 Jul 2014 19:58:01 GMT

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!!!!

regards

Re: Function for strem !!!

jerem1234 — Tue, 15 Jul 2014 20:00:43 GMT

If CM is always the last two letters, then you can use the conditional:

right(items, 2)='CM'

Hope this helps!

Re: Function for strem !!!

Tue, 15 Jul 2014 20:01:11 GMT

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.

regards!!

Re: Function for strem !!!

Tue, 15 Jul 2014 20:05:49 GMT

this way is correct also thanks jerem1234

Regards!!