Customer Portal

Passing Date into a Graph File

Comments 2

  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Hi Vijay,

    The functionality you are looking for is a part of commercial version of CloverETL. The component designed for such purposes is DBJoin (receives data from incoming edge, use them to join with data in a database). However, there is a workaround you might take into consideration. You can prepare the query in another component and send the whole query over the edge into DBInput.
  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Above suggested workaround could be done as follows:

    • Prepare the whole query in preceding component and assign it to output record.

    • In DBOutputTable enter the following:

    port:$0.<QueryFiledName>:discrete 

    For more information about DBOutputTable please refer to: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/index.html

Please sign in to leave a comment.