List of Contributions

Adrian Williams

Employee

Contact Details

My Content

1 to 20 of 50+ total
Posted By Adrian Williams 06-30-2022 13:16
Found In Egroup: Data360 Analyze
\ view thread
You could use regular expressions in a Transform node to extract the date string: See the attached example data flow (zipped). ------------------------------ Adrian Williams Precisely Software Inc. Naperville IL ------------------------------
Posted By Adrian Williams 06-30-2022 13:16
Found In Library: Data360 Analyze
Posted By Adrian Williams 06-28-2022 11:49
Found In Egroup: Data360 Analyze
\ view thread
It is a Connection Point. Connection Points are the replacement for Bundlers, Unbundlers and Bypass nodes that were included in the the Legacy LAE product. See the 'Advanced topics' > 'Connection Points' topic in your system's Help documentation for details. ------------------------------ Adrian Williams ...
Posted By Adrian Williams 06-16-2022 10:35
Found In Egroup: Data360 Analyze
\ view thread
There is no generic, built-in, way to do it in that release. For a particular file you could us this approach: The CSV/Delimited node is configured to read in the data as if the data did not have a header record: The note will then auto-generate field names: A Transform node then configured to clean ...
Posted By Adrian Williams 06-16-2022 08:59
Found In Egroup: Data360 Analyze
\ view thread
Hi Scott, you can use the 'SubstituteInvalidCharacters' property: Regards, Adrian ------------------------------ Adrian Williams Precisely Software Inc. Naperville IL ------------------------------
Posted By Adrian Williams 06-09-2022 05:35
Found In Egroup: Data360 Analyze
\ view thread
To investigate the issue we would need to have some additional information from you. Can you navigate to https://support.precisely.com/  and then, from the main menu use the 'Support' -> 'Create customer case' option, create a technical support case for the issue. We will need details of the Analyze ...
Posted By Adrian Williams 06-07-2022 07:13
Found In Egroup: Data360 Analyze
\ view thread
The key text in the error message is "IndexWriter is closed". This usually indicates you have run out of disk space on the drive/partition that is used to store the temporary execution data generated when running data flows. You can configure the application to automatically purge temporary execution ...
Posted By Adrian Williams 05-31-2022 11:46
Found In Egroup: Data360 Analyze
\ view thread
Hi jaycee, you need to use the Python timedelta objects to adjust a datetime value. Note that the timedelta functions only operate on datetime values, not on just time values so you need to create the datetime object first and then adjust it by the required amount - which results in a new datetime value. ...
Posted By Adrian Williams 05-31-2022 11:02
Found In Egroup: Data360 Analyze
\ view thread
Hi Nathan, You can use the following approach: The value for the FixedLedgerNbr variable is defined in the ConfigureFields script rather than the ProcesRecords script since it only needs to be specified once. The code in the ProcessRecords script is defensive and tests for a Null value in the 'Account ...
Posted By Adrian Williams 05-20-2022 02:51
Found In Egroup: Data360 Analyze
\ view thread
You can also use regular expressions in a Transform node to identify strings with a zip or zip+4 formats: ConfigureFields Script ProcessRecords Script Example results: See the attached example data flow Attached files Check_Zip_Code_Validity - 20 May 20 ...
Posted By Adrian Williams 05-19-2022 04:29
Found In Egroup: Data360 Analyze
\ view thread
Ah, got it now. I was checking the links in the navigation pane and in the body rather than the text that should be in the body. Many thanks for highlighting the issue. I have raised it with the Engineering team. Regards, Adrian
Posted By Adrian Williams 05-19-2022 00:27
Found In Egroup: Data360 Analyze
\ view thread
Thanks for the heads up. However, when I go to the URL in the screenshot all of the links are resolving correctly. The base URL I used is https://doc.infogixsaas.com/api/index.html#_introduction I have tested this from a couple of different machines, both on and off of our corporate network and ...
Posted By Adrian Williams 05-18-2022 06:06
Found In Egroup: Data360 Analyze
\ view thread
Hi Bart, I'm assuming you are referring to the information on this site. The Preview site hosts the documentation that is applicable to the latest release that has been promoted to the site by the Engineering team. It does not necessarily align the latest Generally Available version of the ...
Posted By Adrian Williams 05-17-2022 08:25
Found In Egroup: Data360 Analyze
\ view thread
Unfortunately not. There is an existing enhancement request for functionality . However it is not currently under consideration for a specific target release. Ref. LAE-8755
Posted By Adrian Williams 05-09-2022 01:59
Found In Egroup: Data360 Analyze
\ view thread
As John's reply shows - there are several ways this can be done. Here is an example using regular expressions. ## ConfigureFields Script import re #Configure all fields from input 'in1' to be mapped #to the corresponding fields on the output 'out1' out1 += in1 out1.DigitsOnly = unicode ...
Posted By Adrian Williams 04-14-2022 01:52
Found In Egroup: Data360 Analyze
\ view thread
There have been some delays in the program re. delivery of the new Python 3 node. The roadmap currently has the Python 3 node included as a 'stretch' item in the Data360 Analyze 3.12 LTS release. Note that a stretch item is not committed to the release so there is still a possibility that it may ...
Posted By Adrian Williams 04-07-2022 02:24
Found In Egroup: Data360 Analyze
\ view thread
I understand that following your previous request the following Govern enhancement requests were created/ tagged with you as a client: GOV-15452 - Relationship/Responsibility/Ownership Changes can be a Trigger for Workflows Allow a workflow to be triggered based upon: 1. Change in a specified ...
Posted By Adrian Williams 04-05-2022 08:02
Found In Egroup: Data360 Analyze
\ view thread
The installers are located on the Analyze Downloads page (and you need to be signed in to view the contents of that page): https://support.infogix.com/hc/en-us/sections/360003464673-Downloads The specific page for the v.3.8.4 LTS Server release is here (sign in required): https://supp ...
Posted By Adrian Williams 03-31-2022 07:50
Found In Egroup: Data360 Analyze
\ view thread
Note that as from Data360 Analyze v.3.8.1 you can use a custom CRON expression to define a schedule interval. See the v.3.8.1 release announcement for details. https://support.infogix.com/hc/en-us/articles/4406908363155-Data360-Analyze-3-8-1-is-Now-Available-LTS-Release