AnandKiran
16 years agoFrequent Contributor
How to collect a value retrieved in a database in a property
Hi friends,
Here there is a scenario where i want to collect the value retrieved from a Datasource step and then i want to pass the same value to another datasource step
Step 1: Data source step with query
Select * from CONT where CONT_NBR = '6639010'
I have created two properties in this step CONT_NBR & CONT_ID
Step 2 : Property transfer step which is used to transfer the property CONT_ID
Step 3: Properties Step to store the value CONT_ID
Step 4: Propery transfer step to transfer the CONT_ID
Step 5: Datasource step to check one more query
Select * from CONT_ENTM where CONT_ID = '{{CONT_ID}}'
But step 4 ans step 5 has failed it is not able to transfer the property value collected in step 3 to step 4.
can you help me in this issue .
Thanks
With Regards
Anand Kiran G
Here there is a scenario where i want to collect the value retrieved from a Datasource step and then i want to pass the same value to another datasource step
Step 1: Data source step with query
Select * from CONT where CONT_NBR = '6639010'
I have created two properties in this step CONT_NBR & CONT_ID
Step 2 : Property transfer step which is used to transfer the property CONT_ID
Step 3: Properties Step to store the value CONT_ID
Step 4: Propery transfer step to transfer the CONT_ID
Step 5: Datasource step to check one more query
Select * from CONT_ENTM where CONT_ID = '{{CONT_ID}}'
But step 4 ans step 5 has failed it is not able to transfer the property value collected in step 3 to step 4.
can you help me in this issue .
Thanks
With Regards
Anand Kiran G