The solution depends on your use case, but apart from the option provided by Dimitri, you can consider using Workflow variables. This is the best practice on how to pass value from one workflow to another. You can use variables to pass the information to other tasks, store and pass the information read by other tasks or pass the information outside the current task.
To define a variable in the workflow go to Global properties by right-clicking on canvas and choose tab Variables. We have two types of variables used there derived and input.
The simplest example which comes to my mind is that you can read from the column using Iterator with SQL row Iterator implementation and pass this value to a child workflow where you can run a component and use the values for a file name for example.