List of Contributions

Ernest Jones

Employee

Contact Details

My Content

1 to 20 of 41 total

RE: Change the value of a run property.. at runtime?

Posted By Ernest Jones 05-21-2025 11:30
Found In Egroup: Data360 Analyze \ view thread
Ok. The only current way to set the Run Date automatically is one of the options Adrian mentioned. You can pass the Run Date as an input to the "Execute Data Flow" node. ------------------------------ Ernest Jones *Precisely Software Inc. PEARL RIVER NY ------------------------------

RE: Change the value of a run property.. at runtime?

Posted By Ernest Jones 05-21-2025 11:21
Found In Egroup: Data360 Analyze \ view thread
Just in case this is not clear, and this is not necessarily what you are asking, you can always override the Run Date and Run Time manually in a Schedule that runs the dataflow, and in a Run State. ------------------------------ Ernest Jones *Precisely Software Inc. PEARL RIVER NY ---------------- ...

RE: Accessing Data on Local PC with Desktop Version

Posted By Ernest Jones 03-12-2025 10:47
Found In Egroup: Data360 Analyze \ view thread
I have to start with the simple answer and see where it goes. Normally the Desktop install of Analyze has direct access to the local Windows disks. So I can access files using the path and filename with an address like this C:\Users\ernest.jones\Documents\Book1.xlsx Depending on context though, ...

RE: How to read CSV files within a ZIP file

Posted By Ernest Jones 11-15-2024 12:28
Found In Egroup: Data360 Analyze \ view thread
Andrew, I think what is displayed is dataflow properties, rather than node properties. Click on the canvas, i.e. whitespace between the nodes, to deselect the nodes. Then I think you'll see those properties. ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ----- ...

RE: Create a dropdown menu in an excel column

Posted By Ernest Jones 10-04-2024 09:10
Found In Egroup: Data360 Analyze \ view thread
If you want to store a list object in a string field, you will need to serialize it. You could use the Python repr() function for this. out1.Issue_Owner = repr(dropdown_options) Then when you need that value later on in Python code, use the eval() function: dropdown_options = eval(in1.Issue_Owner) ...

RE: concatenating N amount of columns and values comma separated

Posted By Ernest Jones 04-23-2024 09:54
Found In Egroup: Data360 Analyze \ view thread
I have been doing this a lot lately. I use the Lookup node where the second input somehow specifies the rules for how the data in the first input should be combined. So in this lookup, the fields in the second input are combined into an output field. the name of that output field is specified by the ...

RE: Create a Temporary List or Set in Transform Node

Posted By Ernest Jones 04-22-2024 09:27
Found In Egroup: Data360 Analyze \ view thread
What you are describing that you are doing is similar to what I've done very often lately. So I am pretty sure that the problem you are dealing with is a typo or mistake. Here is a simple way to do what I understand you are asking for using an Agg node: Input: Agg: Note that the second ...

RE: Search for a Future Date using wildcards

Posted By Ernest Jones 04-19-2024 10:10
Found In Egroup: Data360 Analyze \ view thread
Hi Mike, Would it be as simple as using a Filter node to find records that have a date after some date you specify? Ernest ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ------------------------------

RE: Data Flows that are "Locked for Editing"

Posted By Ernest Jones 04-01-2024 09:08
Found In Egroup: Data360 Analyze \ view thread
How about maybe refreshing the browser window without saving first? ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ------------------------------

RE: Batch insert query optimization

Posted By Ernest Jones 03-25-2024 10:05
Found In Egroup: Data360 Analyze \ view thread
Hi Henrik, I am unconvinced that the JDBC Store node is not the better option, but I'll answer. I have not tested to see if this approach to creating that SQL insert statement is faster. I often run across the need to build a single string value using a concatenated lest of values from multiple ...

RE: Calculate Fields Node

Posted By Ernest Jones 02-23-2024 09:08
Found In Egroup: Data360 Analyze \ view thread
What are you wanting to do with a calculate fields node? It looks like that example code is from a ProcessRecords property of a Transform node. So it is not the code that determines what columns to create. ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ---- ...

RE: Excel Node - Import Help!!

Posted By Ernest Jones 01-30-2024 09:08
Found In Egroup: Data360 Analyze \ view thread
I had another thought on what to do with mapping the various column names, because for a production environment I would not want to use a Fuzzy match to column and sheet names because I would not be able to trust it. Instead, what I've seen work well in another context is to create a mapping table. ...

RE: Excel Node - Import Help!!

Posted By Ernest Jones 01-29-2024 11:07
Found In Egroup: Data360 Analyze \ view thread
Hi Andrew, I won't try to answer the question about how to map field names to the fields you are looking for, or sheet names to the sheets you are looking for. Maybe the "Fuzzy Join" could be helpful. I just want to point out that the Excel node can be configured to write the sheets of an Excel file ...

RE: Synchronization of flows within Execute Data Flow Node

Posted By Ernest Jones 01-29-2024 10:49
Found In Egroup: Data360 Analyze \ view thread
Hi The first idea that comes to mind is to use the Sleep node to wait the 2 minutes before starting a dataflow. This attached screen shot shows how it might be structured. Disclaimer: I can't guarantee this will work because it relies on the controller that runs nodes inside dataflows to determine ...

RE: D360 Analyse - Load JSON Lines file using JSON Node

Posted By Ernest Jones 11-27-2023 15:53
Found In Library: Data360 Analyze

RE: D360 Analyse - Load JSON Lines file using JSON Node

Posted By Ernest Jones 11-27-2023 15:53
Found In Egroup: Data360 Analyze \ view thread
Hi Scott, So far, when I've had this problem I have done one of the following: If I don't need that part of the JSON data, I use the ability of the JSON node to split off certain parts of the JSON documents to additional outputs. So for your example, add an output named Attributes.Unde ...

RE: Number Stored as Text Error in Inserting Data in Excel

Posted By Ernest Jones 10-10-2023 10:13
Found In Egroup: Data360 Analyze \ view thread
When loading Excel, the int and long datatypes do get converted to text. You'll need to make those into double types if you want them to appear in Excel as numbers. ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ------------------------------

RE: Find special character and replace it and everything after it

Posted By Ernest Jones 09-29-2023 07:44
Found In Egroup: Data360 Analyze \ view thread
The "Trim Fields" node requires specifying the specific set of characters that will be removed, and it removes all of them. This is not aligned with what I understand to be the result you want. You could solve it using the find() method and slicing: In a Transform node it might look like this: ...

RE: Efficient method of splitting datasets

Posted By Ernest Jones 09-22-2023 09:25
Found In Egroup: Data360 Analyze \ view thread
I don't know the performance requirements you have, nor the performance expectations of the Analyze nodes. I can think of other ways to split up the data that probably run more slowly. You could add outputs to a Transform node and use the Python modulus operator on the value of node.execcount and ...

RE: Flattening rows

Posted By Ernest Jones 09-13-2023 10:15
Found In Egroup: Data360 Analyze \ view thread
My first thought was closer to what Peter Sykes did, but with a Transform node and a Sort. What he did is better than my first thought. Here is an answer that requires no Python code: ------------------------------ Ernest Jones Precisely Software Inc. PEARL RIVER NY ...