Avatar

Adrian Williams

  • Total activity 282
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 106

Activity overview

Latest activity by Adrian Williams
  • Avatar

    Adrian Williams commented,

    Here is an example data flow that shows the Full Outer join use case. The Join node outputs the Left orphan and Right orphan records.     Attached files Join_Node_Example_4.3.2 - 15 Oct 2019.lna  

  • Avatar

    Adrian Williams commented,

    The Help documentation for the Join node describes the operation of the node in relation to the configuration of the node's JoinType property. The Join node is not intended to be a GUI-based SQL bu...

  • Avatar

    Adrian Williams commented,

    Here is a basic example of the use of the date.replace() function. Note: the example assumes the number of months n is between 1 and 12. Supplemental logic would be required to handle an arbitrary ...

  • Avatar

    Adrian Williams commented,

    You may want to consider using the date.replace() function to modify a date value by a specified number of months as described in the documentation on date objects:  https://docs.python.org/2/libra...

  • Avatar

    Adrian Williams commented,

    As Gerry states, the logic for adjusting a datetime.date value by a specified interval uses the Python timedelta object. The basic logic required is as follows (see attached example data flow):   ...

  • Avatar

    Adrian Williams commented,

    As you say, there is no built-in functionality for printing a data flow so printing the screen image is really the only mechanism. At some point most mechanisms to generate a print-out will result ...

  • Avatar

    Adrian Williams commented,

    If the data flow contains many nodes then, in general, the design-time responsiveness of the UI may be improved if Composites are used to group related nodes as there are fewer nodes to render on t...

  • Avatar

    Adrian Williams commented,

    The Postgres tasks are created by PostgreSQL as required and are are used by the Analyze database. These tasks are not associated with the running of nodes.  A number of issues relating to Out Of M...

  • Avatar

    Adrian Williams commented,

    As noted in the Help text for the Append Excel Node, the node provides limited support for the preservation of cell formatting and formulas. You can maximize the amount of information preserved by ...

  • Avatar

    Adrian Williams commented,

    Have you tried using the UNC path format rather than using a mapped drive letter? The information in this post may be of use: https://superuser.com/questions/244562/how-do-i-mount-a-network-drive-t...