Good Afternoon everyone! I have an interesting use case where I'd like to use an exported CSV file that I would import into Data Blaze that would contain the quantity of the materials needing to be ordered as well as the model number. I am running into an issue where automating the movement to grab the information from the next row after the first is completed. Does anyone have a suggestion or directions on how I can accomplish this?
The quoted text are comments in the picture attached to understand the flow that I am looking for.
To do this, give a name to your dbselect command. That name will be populated with a list of all the rows returned by the dbselect. Then use the {repeat} command to iterate through the list.
You will end up with something like the following:
{dbselect: select name, count from table; space=1234; multiple=yes; name=models}
{repeat: for model in models}
{=model.name} has count {=model.count}
{endrepeat}
Hey, Scott thanks for the reply. Andrew Hall has reached out, and we are also working on this. I guess I am just not explaining what I am trying to accomplish correctly. Let me see if I can clarify and get back to you.