Table to Tree?

Discussions
1

Is there a way to convert a Table into a Tree? I’ve previously used XML files in Vuo and am hoping there is a way to pull data out of a .csv file in a similar way. Basically I’ve been given spreadsheet data provided in .csv format that I’m hoping to fetch rows of data based on queries that match a specific column of the data.

Here is an example:

ID# First Name Last Name
0001 Amy Gross
0002 Jiminy Cricket
0003 Andy Milner
0004 Tiffany Gilly
0005 Bob Smith

If you input 0004 it responds with Tiffany Gilly, input 0002 it respond with Jiminy Cricket. etc. Is there a way to convert a Table to a tree so I can use ‘Find Subtrees using XPath’ and Find Subtrees with Name to pull out the data I’m looking for?

2

Chris,

Can you convert the CSV to XML or JSON? Then you could load it using Vuo’s Tree nodes and use “Find Subtrees Using Xpath” to search it.

3

Jean Marie, that’s what I ended up doing, because this will be an ongoing thing I was hoping to find a native way to support it directly.

4

We’re discussing a Find Table Row node for a future (undetermined) release.

5

Added Find Table Row node in Vuo 2.0.0-beta2.

1 Like
6

This is fantastic! Thank you so much!

1 Like