03-15-2021 07:43 AM
Hello,
I am trying to create a program with a "ring" in order to be able to act as a case structure later on. But I want the values from the "ring" to be read from an excel file so I can add cases without having to modify the program.
Since I am just starting to play with it I created and excel with 3 columns. First column is the ring item, second column is the ring value, and the last 2 columns are just first name and last name.
I worked out the logic that I think could work. But unfortunately I have an issue with the output result because of the type of date. In order to use a property node on the ring to modify the values and items (stringsandvalues) it must be a 1D array of cluster of 2 elements. I have the 2 elements and when I use bundle I get a cluster of 2 elements with 2 of the 1D arrays. The program doesn't like this so it wont run.
Thanks for all the help and ideas.
Solved! Go to Solution.
03-15-2021 07:54 AM
You have it backwards. You have a cluster of arrays. You need an array of clusters. Try using Build Clusters Array instead of the Bundle.
03-15-2021 09:08 AM
Thanks for your response. I tried using build clusters array but it doesn't work either because its two different types of data. Any idea on how to fix this??
03-15-2021 09:14 AM - edited 03-15-2021 09:15 AM
03-15-2021 09:57 AM
Thanks a lot. It worked perfectly.