topic Re: One line with two characteristics in QlikView

One line with two characteristics

Thu, 31 Jul 2014 00:41:35 GMT

How can i do a treatment of table with two values like?

Header 1

Algoritmo

Header 3

Header 4

KNN

PARZEN

KNN

BAYES

PARZEN

BAYES

I want to work filtering just on Algoritmo in Column each time

Re: One line with two characteristics

avinashelite — Thu, 31 Jul 2014 03:25:06 GMT

Can you please elaborate your problem

Re: One line with two characteristics

tresB — Thu, 31 Jul 2014 04:28:50 GMT

You have to use Subfield(). But for that, there has to be a separator between two values. Assuming that your Algoritmo field values are separated by a space (like: Value1 Value2), you could try something like:

Load

Field1,

...,

SubField(Algoritmo, ' ') as NewAlgoritmo

From <>;

Here, subfield() would generate one full record of input data for each substring that can be found in the original string.

Therefore, all you have to find is a separator.

Re: One line with two characteristics

aveeeeeee7en — Thu, 31 Jul 2014 04:48:03 GMT

Hi Alysson

Though your Requirement is not clear but as per my understanding, in your case

you can use chr(13)

eg. Field1&chr(13)&Field2

or you can use Subfield() function as Tresesco Sir said.

Regards
Aviral Nag