Hi, I got a set of values that I want to put in from sheet hp to sheet hfm, is it possible for me to do that?
Hi @terrellchong, you can copy the result of one workflow and input it into the second.
1) Insert a browsing tool at the end of your workflow.Click on the button marked with red then copy all the records with header.
2) Insert a Text Input tool then paste all the records into it, by clicking the button circled with red.
In this way you can use the output of sheet hp as input of sheet hfm.
Other way is using an output tool and save the file as csv then put that file into the other workflow in case your data is dynamic and you are not willing to update your input file over and over again in hfm workflow sheet.
I hope this helps.
Thanks!
I do not believe you can transfer individual records by drag and drop-like actions the way you seem to be contemplating doing.
However it is not hard to transfer records between workflows. One way to solve your issue is to output the set of values of interest using an output tool and then use an input tool to import them into the other workflow. You will then need to join/union/append the records as appropriate in order to add them into the other workflow's data stream.
I didn't know about that option @grazitti_sapna!
Will this transfer approach conserve the original meta-data encoding in the other workflow, or will he run into the usual potential problems with the text input tool (where integers are loaded as strings or bytes, etc.)?
Oh, I was hoping that this can be done so that I can one go automate most of the stuff. If this is the case then I'll have to move them both in one workflow.
