Avatar

Adrian Williams

  • Total activity 985
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 2
  • Subscriptions 397

Activity overview

Latest activity by Adrian Williams
  • Avatar

    Adrian Williams created an article,

    Generating Tomorrow's Date as a Formatted String

    You may need to create a variable that has the value of tomorrow's date as a string. Here's one way you can achieve this using some Python scripting in a Transform node.   The ConfigureFields scrip...

  • Avatar

    Adrian Williams commented,

    I'm not too sure what you mean by "reverse it" - can you clarify what you are trying to achieve? However, you can convert a string representation of a datetime value with the timezone ("2021-04-07T...

  • Avatar

    Adrian Williams created an article,

    Running Data Flow Logic on Custom Days of the Month

    The in-built Data360 Analyze scheduler enables you to automate the execution of a data flow with a selection of different periodicities - without the need to use coding. However, in some situations...

  • Avatar

    Adrian Williams commented,

    Would you be able to supply a DRD file with a couple of records of example data that causes the Output Excel node to error?

  • Avatar

    Adrian Williams commented,

    Update: We recommend using the default microsoft driver for SQL Server instead of the jTDS driver. Starting from Data360 Analyze release 3.6.8 the Microsoft driver can be used with Windows Authenti...

  • Avatar

    Adrian Williams commented,

    Update: We recommend using the default microsoft driver for SQL Server instead of the jTDS driver. Starting from Data360 Analyze release 3.6.8 the Microsoft driver can be used with Windows Authenti...

  • Avatar

    Adrian Williams commented,

    If the Windows share has been mounted on the Linux machine using Samba then you should be able to write a file to the share in the same way as writing to a location on the local file system. The fi...

  • Avatar

    Adrian Williams commented,

    The Connector in the <install directory>/tomcat/conf/server.xml redirects incoming connections on port 8080 to port 8443. Given the other SSL-related changes you have made to configure the applicat...

  • Avatar

    Adrian Williams commented,

    Here is an example of the different methods   Attached files Compare_Year_Values.brg  

  • Avatar

    Adrian Williams commented,

    The simplest approach would be to convert the Year string to an integer value and then compare it with 2020.  If the field to be tested contained a date string you could strip out the year characte...