Pass variable value to mapping and read the same variable value in the process
N
Nelrick RODRIGUES
started a topic
7 months ago
Semarchy xDI version: 2023.1.7
We have a specific requirement to load data to a postgres table and also pass a column value to a variable (process_id) , since we need to refer it in the process again.
We can't query the table to get the process_id directly since the process is called multiple times concurrently, hence we want to pass the process_id to a variable in the mapping.
Now, we need to use the same process_id variable again in the process to use it as an input for another mapping.
Please let me know how to implement this scenario.
Best Answer
A
Audric FREY
said
about 2 months ago
Hello,
There is no way to pass a variable in a mapping to a process.
You can initiate a variable in a process and use it in a mapping but not the opposite.
You should create a new target table, or file to store the value you want to pass.
And query this new table or read the file to retrieve the value and use it in your process or next mapping.
1 person has this question
1 Comment
A
Audric FREY
said
about 2 months ago
Answer
Hello,
There is no way to pass a variable in a mapping to a process.
You can initiate a variable in a process and use it in a mapping but not the opposite.
You should create a new target table, or file to store the value you want to pass.
And query this new table or read the file to retrieve the value and use it in your process or next mapping.
Nelrick RODRIGUES
Semarchy xDI version: 2023.1.7
We have a specific requirement to load data to a postgres table and also pass a column value to a variable (process_id) , since we need to refer it in the process again.
We can't query the table to get the process_id directly since the process is called multiple times concurrently, hence we want to pass the process_id to a variable in the mapping.
Now, we need to use the same process_id variable again in the process to use it as an input for another mapping.
Please let me know how to implement this scenario.
Hello,
There is no way to pass a variable in a mapping to a process.
You can initiate a variable in a process and use it in a mapping but not the opposite.
You should create a new target table, or file to store the value you want to pass.
And query this new table or read the file to retrieve the value and use it in your process or next mapping.
1 person has this question
Audric FREY
Hello,
There is no way to pass a variable in a mapping to a process.
You can initiate a variable in a process and use it in a mapping but not the opposite.
You should create a new target table, or file to store the value you want to pass.
And query this new table or read the file to retrieve the value and use it in your process or next mapping.
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Dropping multiple tables at once in XDI
-
Freeze Designer and corrupted workspace
-
FileWait/Move/Copy: FileInclude with space
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 64 topics