Hello.
I was wondering how to create “StringArrayType” flow variable.
When I tried to convert List type row to flow variable by using Table row to variable, it didn’t work.
I’d appreciate it if someone could help me.
Best Regards,
hhkim
Hello.
I was wondering how to create “StringArrayType” flow variable.
When I tried to convert List type row to flow variable by using Table row to variable, it didn’t work.
I’d appreciate it if someone could help me.
Best Regards,
hhkim
Hey there,
I always do this by getting all values into one column then use group by and go with aggregation Set or list in that column without group columns.
Then use table row to variable node
Hi @hhkim , I sometimes have a need to quickly create a string array from a set of literal values, so I have a couple of components to make my life easier. Behind the scenes, iirc, the components probably do this in much the way @MartinDDDD describes.
I also have one dedicated to turning the column headings into an array variable:
Slightly off topic, but on a related theme… I also have a couple of components that I wrote recently for providing information about Collection type data columns .
These components effectively “wrap” the Column Expressions node (so you’ll need the KNIME Column Expressions extension installed first), and provide some mechanisms for inspecting and manipulating data in a collection column…
Finally, you may also be interested in the Vernalis extension nodes relating to collection columns.
https://hub.knime.com/search?type=all&tag=Collections&sort=maxKudos
Mate you got components for everything! Kudos
Lol, thanks @MartinDDDD .
The one thing missing from my KNIME life is a “quick access” panel for favourite components built into KNIME, in the same way that we can select nodes.
It’s great having components but a bit of a chore having to find them on the hub each time, so instead I place some of them on a dedicated Workflow for copy and paste which isn’t perfect but better than nothing.
Well make that a feature request :D. You got my upvote for sure ;).
Would be a nice quality of life feature!