LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: roeperg

Hi

I am looking for a way to run a set of nodes multiple times using values from a BRD file. Right now I have a composite node with a DB Query and a CSV output file. Both of the nodes use a graph level parameter called Employee_ID; the query uses it in the SQL to pull the correct records and the csv output uses it to name the file. I want to be able to use a list of Employee_IDs and have the composite run discreetly for each value, producing a group of csv files each named for the Employee_ID.

Suggestions?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

You want to use the Execute BRX node, which can run a graph with the input to the node being the parameters that will be used for the sub-graph.

To do this, you want to take the set of nodes that you are currently running and want to iterate over, and make them a separate graph. Take any parameters that you want to supply from the parent graph, and make them runtime parameters at the graph level. Then take that graph and save it as a .brx on your server (File/Save as BRX...).

In your current graph, you would place the Execute BRX node in place of the set of nodes you currently have, and you can then parameterize all those nodes with values from the input to the Execute BRX node.

If you want to get data out of the those nodes (now the sub-graph), and back into the parent graph, you can use the Output BRD File and BRD File nodes for outputting and then inputing into your current graph.

Let me know if you need help or more details in how to do this.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

One quick note here: for ExecuteBRX to work properly in a Windows environment, you need to use double quotes around the BRXname if it contains spaces.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

I've modeled an Execute BRX graph according to the requirements provided originally in this post. See attached.

- Bob
Attachments:
ExecuteBRDInput.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: credoblado

Hi,
Can this graph be executed using Lavastorm Desktop ?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

Yes, in fact it was created using the Lavastorm Desktop.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

I realized today that my previously posted example lacked the input .BRD data file. Attached is example complete with input data.
Attachments:
ExecuteBRDInput2.zip