Hi All,
i have 2 tables. 1.project(id,requesttype,automationname,etc), 2.Task(id,projectid,workflowtype,etc)
Project:{ { "",test,test}, {"",test,test},{"",test,test}}
task:{{ "","",task}, {"","",task},{"","",task}} }
for example After write to data store entity of my project data is{ { 1,test,test}, {2,test,test},{3,test,test}}
once project data is created i want to create the task respectively before that i want to assign the PROJECT DATA (ID) which is 1,2,3 to Task Data(PROJECTID)
finally after i write the task data into db i want my task data as: {{1,1,task},{2,2,task},{3,3,task}}
can you please help how i can set the id of project to particular cloumn in the task data
Discussion posts and replies are publicly visible
Hi anithad,
From the Project Write to data store entity take the output of stored values in a pv of type Project and when configuring write to Data store for Task use pv!Project.id as value for Task's projectId.
Or, you can also add a script between 2 write to DSEs and use it to store the project id in the task id. Use the output tab and create a custom output.
Thanks Sanchit and Harshit, i used script task between the 2 DSE and set the value.. its worked now. Thanks