List of Contributions

Tim Segall

Employee

Contact Details

My Content

1 to 10 of 10 total

RE: Reimplement Pivot nodes in new syntax

Posted By Tim Segall 02-16-2021 14:50
Found In Egroup: Data360 Analyze \ view thread
In terms of performance - the new node is dramatically faster. In my brief testing typically 15 to 100 times faster. For example, the new node processed 60 million rows in ~18 minutes.

RE: How to found latest date.

Posted By Tim Segall 11-27-2017 05:28
Found In Egroup: Data360 Analyze \ view thread
Kristian, *** The following answer assumes you are on 3.1.6 *** Take the above output and output it into an Aggregate node. Set the GroupBy to 'name' and the Operation to be Max of login and you should get what you want. Note: This assumes your login field is a date, if it is not ...

RE: Losing precision in query results from JDBC

Posted By Tim Segall 09-25-2017 09:07
Found In Egroup: Data360 Analyze \ view thread
Robert, One of the Engineers had a look at this issue and there is potentially more detail here than you want to know. The core issue is that the information available from the JDBC driver is limited. In the information returned from the JDBC driver the metadata tells us that the calculated ...

RE: 3.1.5 Transform Node and Python

Posted By Tim Segall 09-20-2017 04:31
Found In Egroup: Data360 Analyze \ view thread
Nancy, If you want to suppress records in a transform node you need to set the output to None based on the condition you have identified. The example below based on Mark's above should give you all the information you need. Step 1 Create a Create Data node with the following content in ...

RE: Windows Server 2008R2

Posted By Tim Segall 09-13-2017 08:46
Found In Egroup: Data360 Analyze \ view thread
Kevin, The Server OS's supported are listed in the Server Installation Guide - available here https://installers.lavastorm.com/Dataverse315/Server/Dataverse+Server+Installation+Guide.pdf. But in short, the only Windows OS currently supported by Dataverse is Windows Server 2012R2 64-bit. We ...

RE: Windows Server 2008R2

Posted By Tim Segall 09-13-2017 07:59
Found In Egroup: Data360 Analyze \ view thread
Kevin, Assuming you are asking whether Dataverse can access SQL Server running on Windows Server 2008R2 the answer is yes. Dataverse ships with sqljdbc4-4.2.jar which can access Microsoft SQL Server 2008R2. Cheers, Tim.

RE: Change metadata

Posted By Tim Segall 09-08-2017 12:56
Found In Egroup: Data360 Analyze \ view thread
Simplest solution is probably just to hook the output of the Excel node to a new Transform node. In the new transform node, you need to create a new Field (named Description) with the contents of the blank field. Then you need to remove the old blank field. The ProcessRecords just copies the records. ...

RE: Error on look up node - Maximum Buffer Size

Posted By Tim Segall 09-04-2017 13:49
Found In Egroup: Data360 Analyze \ view thread
Martin, As per the documentation https://preview-desktop.lavastorm.com/#e-node-help/Correlation/lookup.html?Highlight=lookup this node 'Enriches a large data set (left table) with a small data set (right table) by joining the two data sets based on common fields.' This node is meant for one ...

Help on a Node property

Posted By Tim Segall 08-24-2016 14:03
Found In Egroup: Data360 Analyze \ view thread
Select the node on the Canvas, then hover over the property nameon the Properties Panel (Panel on the RHS).

Right Click on the Canvas

Posted By Tim Segall 08-24-2016 13:55
Found In Egroup: Data360 Analyze \ view thread
If you need to insert a Composite or Paste a node at the cursor then just right click on the Canvas.