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