R should return 2 columns

[FTheisohn]

Hi again,

i like to calculate the frequency of distinct integer values in a table. Therefore I am using a "R-Sniplet" Node with the following command:

R<-table(val1)

the return is only the frequency of every value in val1, but not the corresponding value. I would like to have an Table like this:

value frequency
1 2
2 3
3 1
...

where val1 is maybe:
1
1
2
2
2
3

any idea how to manage this? :roll:

Greetings

Frank Theisohn

[unknown_user]

Currently the R Snippet node only supports lists, arrays, vectors, and single elements of type double, int, and string - in one of our future releases, we will also support matrices. It's pretty high on my todo.

Anyway, to overcome this problem, you can use two R Snippet nodes, one outputs the attribute values and the other the frequencies, that is,
R<-names(table(val1))
and
R<-table(val1)
The Joiner node can then aggregate the two R results into one table. Make sure you handle duplicate column names within the Joiner node's dialog. Finally it should look similar to this screenshot:

Note, both R nodes need to be executed one after the other, since the variable R is used within both nodes as result value.