Avatar

felix.stuyck

  • Total activity 23
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 4
  • Subscriptions 7

Activity overview

Latest activity by felix.stuyck
  • Avatar

    felix.stuyck commented,

    The ? worked!Indeed the DBname in the code was redundant and specified in the connection details.Thank you for the help!

  • Avatar

    felix.stuyck created a post,

    JDBC execute - use input in SQL querry

    Hi, I am trying to use input data in my SQL code, but something seems wrong. The goal is to remove the records form an SQL table that have a Run_date that i specify in D3S. Code in the JDBC execute...

  • Avatar

    felix.stuyck commented,

    Thank you, the proposed solutions works as desired.The code in the transform node was especially helpful.

  • Avatar

    felix.stuyck commented,

    I want to output the input and if there are more than 10 input records I want to show a random sample of 10.In short: 0 -> 0 7 -> 7 1888 -> 10

  • Avatar

    felix.stuyck created a post,

    Random sample of 10

    Hi, I want to select a random sample of 10 records.Depending on the input data, the input for this node might not always be 10.Any ideas for a work around?

  • Avatar

    felix.stuyck commented,

    Hi, I am working on v3.5.1.5606.Find attached some dummy data, and an extract of the canvas that show the above screenshots.   Attached files Null issue - 22 Nov 2019.lnaDummy data.xlsx  

  • Avatar

    felix.stuyck commented,

    Thank you for the response, the proposed solution works. However, the excel that is uploaded does not contain any whitespace characters.Running the Profiler node gives me the following output: This...

  • Avatar

    felix.stuyck created a post,

    Excel show Null values

    Hi,   When importing data from an excel file, Null values are not correctly shown?  Is there a way to transform these blanks to null values?

  • Avatar

    felix.stuyck created a post,

    Split a record into several lines

    Hello, I have a records with a start date and an end date. I want to split it as follows in the transform node: The following code is not working: count = 0while count < NumMonths :  out1 += in1  ...

  • Avatar

    felix.stuyck created a post,

    Remove library nodes

    Hi,   I wanted removed some unused library nodes so I deleted them in my directory. Now I can not acces my canvas and I get an error message (see screenshot).   Attached files library nodes.png