Skip to main content
Solved

Create a Private Parameter Value From Attribute Value

  • August 1, 2018
  • 2 replies
  • 1074 views

I am trying to create a Private Parameter Value from an Attribute Value.

What I Have is a SQLCreator that is pulling two columns from a table.

ROUTE_ID

 

SYSTEM_CODE

The SQLCreator is using a Published Parameter to query out the data associated the user defined SYSTEM_CODE.

What I want to do is assign a Private parameter from that result as the ROUTE_ID value.

This would allow me to run other queries based on the Route_ID which is a unique number.

Best answer by jkr_wrk

A parameter value is something you typically set before you run your workspace. These are the base parameters.

If you need a value that is dynamic set, you should store it in a variable and get it from there. You could use a AttribureCreator, a FeatureJoiner/FeatureMerger or a VariableRetriever and VariableSetter. (make sure the Setter is done before the Retriever is started).

If you really want to set the parameter, what I don't think you need, you could get the variable and start a WorkspaceRunner with that parameter set. In this case it would be a public parameter I guess.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

jkr_wrk
Influencer
Forum|alt.badge.img+35
  • 424 replies
  • Best Answer
  • August 1, 2018

A parameter value is something you typically set before you run your workspace. These are the base parameters.

If you need a value that is dynamic set, you should store it in a variable and get it from there. You could use a AttribureCreator, a FeatureJoiner/FeatureMerger or a VariableRetriever and VariableSetter. (make sure the Setter is done before the Retriever is started).

If you really want to set the parameter, what I don't think you need, you could get the variable and start a WorkspaceRunner with that parameter set. In this case it would be a public parameter I guess.


  • Author
  • 3 replies
  • August 1, 2018

A parameter value is something you typically set before you run your workspace. These are the base parameters.

If you need a value that is dynamic set, you should store it in a variable and get it from there. You could use a AttribureCreator, a FeatureJoiner/FeatureMerger or a VariableRetriever and VariableSetter. (make sure the Setter is done before the Retriever is started).

If you really want to set the parameter, what I don't think you need, you could get the variable and start a WorkspaceRunner with that parameter set. In this case it would be a public parameter I guess.

Thanks @jkr_da I was able to accomplish this with the featuremerger. I guess my original question was geared more towards running a series of SQLCreators based off of Parameter values enclosed in the where clause. Basically to limit the amount of records being read to speed up the workspace. However your answer solved my issue! Thanks!!