List of Contributions

Adrian Williams

Employee

Contact Details

My Content

1 to 20 of 50+ total

RE: Parquet Input/Output

Posted By Adrian Williams 07-25-2024 04:51
Found In Egroup: Data360 Analyze \ view thread
There are currently no product nodes that generate Parquet format files. However, the Azure Datalake Storage Put node can can be used to upload files to ADLS Gen.2 https://help.precisely.com/r/Data360-Analyze/3.14/en-US/Data360-Analyze-Server-Help/Node-help/Output-Connectors/Azure-Datalake-Storage-Put ...

RE: License is limited to 6 CPU cores

Posted By Adrian Williams 07-24-2024 10:17
Found In Egroup: Data360 Analyze \ view thread
Hi Mehmet, The Free version of the Data360 Analyze Desktop product is intended to allow prospective customers to investigate the capabilities of the application in their own timeframe. The Free version provides access to the core functionality of the product but does however come with some restrictions ...

RE: Consecutive Days Worked

Posted By Adrian Williams 07-24-2024 08:53
Found In Egroup: Data360 Analyze \ view thread
Here is a zip file containing the example data flow for use with an Analyze v.3.12 system: ------------------------------ Adrian Williams Precisely Software Inc. ------------------------------

RE: Consecutive Days Worked

Posted By Adrian Williams 07-24-2024 08:52
Found In Library: Data360 Analyze

RE: Consecutive Days Worked

Posted By Adrian Williams 07-24-2024 06:25
Found In Library: Data360 Analyze

RE: Consecutive Days Worked

Posted By Adrian Williams 07-24-2024 06:25
Found In Egroup: Data360 Analyze \ view thread
One approach would be to sort the working days data by employee (employee ID) and date. You can then process each employee's data as a group in the transform node using the node's 'GroupBy' property to indicate which field defines the group a record is associated with. You can then for each employee ...

RE: How to exclude a certain fields using Transform node?

Posted By Adrian Williams 07-10-2024 08:19
Found In Egroup: LAE \ view thread
Hi Daniel, The Transform Node's ConfigureFields script would include the following code where Field_to_Exclude is the name of the field to be excluded: #Configure all fields from input 'in1' to be mapped #to the corresponding fields on the output 'out1' out1 += in1 if "((^Field_to_Exclude^))" ...

RE: Output csv Format Issue = Amounts

Posted By Adrian Williams 06-25-2024 05:39
Found In Egroup: Data360 Analyze \ view thread
In Data360 Analyze a field that has a data type of double does not permit the use of the thousands separator character e.g. "," in the value so I assume the value being output is actually a unicode/string value. The Output CSV/Delimited node will automatically include the quote characters around a ...

RE: Incomplete Time Series

Posted By Adrian Williams 06-18-2024 06:55
Found In Library: Data360 Analyze

RE: Incomplete Time Series

Posted By Adrian Williams 06-18-2024 06:55
Found In Egroup: Data360 Analyze \ view thread
You can use the following code in a Transform node to add further records to the existing data set. In this case the calculated values are being output in different fields so you can see what is being generated. The values for the new records increment the last received datetime (string) value by one ...

RE: New Fixed Format node does not work correctly

Posted By Adrian Williams 05-31-2024 11:16
Found In Egroup: Data360 Analyze \ view thread
Hi Geoff, I have reproduced the issue you reported. The node should permit you to enter the field definitions on separate lines (as noted in the node help). I believe this is a bug and have forwarded the information to the Engineering team for review. For now I would suggest you continue to use the ...

RE: BrainScript "firstInGroup" equivilent in py/transform node

Posted By Adrian Williams 05-30-2024 04:19
Found In Egroup: Data360 Analyze \ view thread
Hi Edward, The Transform node does support group positional identifiers (node.firstInGroup and node.lastInGroup). These are discussed in the Help documentation, see the following topic: Data360 Analyze Server Help > Python scripting > API and script bindings Specifically, the section on the node ...

RE: Row Hash optimization, Data comparison/validation test

Posted By Adrian Williams 05-30-2024 03:25
Found In Egroup: Data360 Analyze \ view thread
Ah, my apologies, there was an element missing in the original logic that I have also corrected in my original message above. The new statement updates the logic to hash the values of the fields and now produces the same results as your code. strRow = "".join(str(in1[strCol]) for strCol in in1) ...

RE: Row Hash optimization, Data comparison/validation test

Posted By Adrian Williams 05-29-2024 11:49
Found In Egroup: Data360 Analyze \ view thread
The Calculate Fields node is not really suitable for this type of treatment as there are multiple steps, each of which need the output of the previous step to create the final result. The Transform node is more appropriate and provides a more transparent view of the processing being performed on the ...

RE: Filter Results for Last 7 Days

Posted By Adrian Williams 05-29-2024 09:46
Found In Egroup: Data360 Analyze \ view thread
Assuming the reference field in the input data has a data type of datetime, you can use the following script in a Transform node to filter the required records. Note, change the input field reference in the ProcessRecords Script (fields.test_Datetime in the example) #### Start of ConfigureFields ...

RE: How can I Add a numbered Index column to my data?

Posted By Adrian Williams 05-12-2024 02:23
Found In Egroup: Data360 Analyze \ view thread
You can do this in a Transform node with some Python scripting. The ConfigureFields script is executed once when the node is run and this happens before the first record is read/processed. The metadata and initial value of the counter variable used for the index (Rec_ID) is defined in the ConfigureFields ...

RE: Authentification method for Azure blob nodes

Posted By Adrian Williams 05-09-2024 10:24
Found In Egroup: Data360 Analyze \ view thread
The value for the AccountName property is the Azure 'Storage Account Name' https://learn.microsoft.com/en-us/azure/storage/common/storage-account-overview#storage-account-name The value for the AccountKey property is the Azure 'Storage Account Key' https://learn.microsoft.com/en-us/purview/ ...

RE: Dbt support

Posted By Adrian Williams 05-09-2024 08:59
Found In Egroup: Data360 Analyze \ view thread
Product enhancements need to be submitted to the Precisely Product Management team by creating a new idea on the Precisely Ideas Portal. This will enable the Product Management team to review the enhancement and, if it has potential, the idea can be voted on by other customers to enable the team to better ...

RE: Data3Sixty Data Flow time to complete

Posted By Adrian Williams 05-08-2024 06:51
Found In Egroup: Data360 Analyze \ view thread
Information on the start and finish times of a data flow will be included in the system's /logs/lae-audit.log file and, depending on the time period when the data flow is running the information may also be located in any 'rotated' audit logs (which will be named lae-audit.log.yyyy-mm-dd). The attributes ...

RE: How to import pdf documents

Posted By Adrian Williams 04-30-2024 06:04
Found In Egroup: Data360 Analyze \ view thread
Please note that, per the original reply that provided the example data flow "The data flow assumes the PyPDF2 package has been imported into the 'lib/jython2' directory within the Analyze system's 'site' directory (and is hence on the default search path used when the system attempts to locate the ...