Focal Point
[SOLVED] Get a Column out of Dataflow and use the column in process flow[SOLVED]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6327077986

March 28, 2018, 09:11 AM
srajeevan
[SOLVED] Get a Column out of Dataflow and use the column in process flow[SOLVED]
Hi,

I have a data flow which loads data from a csv file to a target SQL table.
I have the data flow placed in a process flow and for logging the flow details to another sql table,i need to use a column value from the data flow in process flow procedures i have.
How can i get column value from the data flow?

This message has been edited. Last edited by: FP Mod Chuck,


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
March 30, 2018, 02:03 PM
FP Mod Chuck
Srajeevan

I just wanted to make you aware if you click on the data flow canvas a properties that includes Record Logging will appear. You can choose All Transactions which will create a flat file of all columns used in the data flow. Otherwise the only way I can see to accomplish logging to a sql table is by creating another data flow with that table as the target.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 02, 2018, 11:01 AM
srajeevan
Hi Chuck,

Thanks for the workarounds.
You have answered my similar question and i am gonna try that solution.
SO i will close this questions as Solved.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL