List of Contributions

Adrian Williams

Employee

Contact Details

My Content

1 to 20 of 50+ total

RE: Password Protected Excel

Posted By Adrian Williams 06-06-2023 09:28
Found In Egroup: Data360 Analyze \ view thread
The Output Excel node does not support the creation of password protected Excel files. You may want to create a request for this functionality on the Precisely Ideas portal as this makes the request visible to the Product Management team and would allow other users to vote for it. As a work around ...

RE: Convert Row into field names?

Posted By Adrian Williams 05-31-2023 06:31
Found In Egroup: Data360 Analyze \ view thread
Please see the attached zip file containing an example data flow. ------------------------------ Adrian Williams Precisely Software Inc. ------------------------------

RE: Convert Row into field names?

Posted By Adrian Williams 05-31-2023 06:30
Found In Library: Data360 Analyze

RE: Swedish encoding

Posted By Adrian Williams 05-17-2023 11:13
Found In Egroup: Data360 Analyze \ view thread
What is the data type assigned to the 'color' field in the Static Data node?It should be unicode instead of string as your value contains non-ASCII values. If it was set to string data type your comparison statement in the Transform node is comparing the set of ASCII characters that comprise "röd" against ...

RE: Python Node

Posted By Adrian Williams 05-10-2023 05:01
Found In Egroup: Data360 Analyze \ view thread
Yes it is possible, with some restrictions. The following information applies to the Python node. See the Analyze Help documentation for installing pure python modules for use with Jython-based nodes (e.g. Transform, Generate Data). The Python node is based on Python 2.7 so any packages you want to ...

RE: D360 Log Files - Find SQL on server

Posted By Adrian Williams 05-09-2023 03:51
Found In Egroup: Data360 Analyze \ view thread
There is no specific timescale for the next release of AnalyzeCli the .639 build you are running is the latest available release. The warning message is potentially a bit strongly worded and it is really just an indication that the server version does not match that of the client. ------------------------------ ...

RE: Output Excel - File Name

Posted By Adrian Williams 05-04-2023 10:29
Found In Egroup: Data360 Analyze \ view thread
The product enhancements such as this are driven by the overall level of customer demand. I looked on the Precisely Ideas portal but there does not appear to be an existing request for it. The Product Management team regularly review the ideas on the portal and consider the number of votes when determining ...

RE: Output Excel - File Name

Posted By Adrian Williams 05-04-2023 10:04
Found In Egroup: Data360 Analyze \ view thread
The Output Excel node (and Append Excel node) does not support the option to specify the name of the output file from the value of an input field - The filename must be a literal value. The context menu on the node's 'File' property is a generic UI widget and it is there to permit you to specify the ...

RE: D360 Log Files - Find SQL on server

Posted By Adrian Williams 04-27-2023 06:50
Found In Egroup: Data360 Analyze \ view thread
I don't know of any method of performing a bulk search operation via the Analyze UI. However, you can use the AnalyzeCli command line tool to perform a search of parameter values for a given string. The details for AnalyzeCli can be found at https://doc.infogixsaas.com/analyzecli/Default.htm The information ...

RE: Schedule/graph tatus

Posted By Adrian Williams 04-27-2023 05:54
Found In Egroup: Data360 Analyze \ view thread
There is a description of the meaning of the run status icons in the Help documentation (Scheduling -> Viewing runs topic) https://doc.infogixsaas.com/analyze/Default.htm#i-scheduling/Scheduled-runs.htm The reason for a Skipped run is that a scheduled run could not be started because a previous run ...

RE: On Prem Analyze - proxy url workaround

Posted By Adrian Williams 04-18-2023 07:02
Found In Egroup: Data360 Analyze \ view thread
I checked with the Engineering team but unfortunately there does not appear to be a mechanism to configure HTTP proxy support on the node itself. This would require a change to the node's code. ------------------------------ Adrian Williams Precisely Software Inc. ------------------------------

RE: Send email many inputs

Posted By Adrian Williams 04-12-2023 06:39
Found In Egroup: Data360 Analyze \ view thread
No you would need to insert some logic to combine the rows into a single record, de-duplicate the records or filter out the unwanted records before presenting the records to the Send Email node. Regards ------------------------------ Adrian Williams Precisely Software Inc. ----------------------- ...

RE: Unexpected Error Help

Posted By Adrian Williams 04-05-2023 04:44
Found In Egroup: Data360 Analyze \ view thread
I'm not sure the error message relates to whether there are Null values in the DB Store node's input data. It may be that there is a problem with the data flow itself rather than the particular node. You could try running the 'Apply Auto-Fixes' tool from the Errors panel to see whether that rectifies ...

RE: Unable to put the content of a file to Azure

Posted By Adrian Williams 04-04-2023 10:32
Found In Egroup: Data360 Analyze \ view thread
When the (Body from field) option is chosen for the HTTP node's 'Body' property the value for this property is sourced from the input field with the name specified. Some nodes such as the JSON Data node provide a (from Filename) variant for certain properties that allow you to specify the name of the ...

RE: Calculating max dates with transform node

Posted By Adrian Williams 03-29-2023 05:31
Found In Egroup: Data360 Analyze \ view thread
I think I would move towards using an approach similar to Peter's. Modify the Sort node to only output a single record for each date value by setting the 'Unique' property to True: Then use a Head node to output the first N=3 records: Then use a Join node to perform an Inner join on the ...

RE: Calculating max dates with transform node

Posted By Adrian Williams 03-28-2023 09:55
Found In Egroup: Data360 Analyze \ view thread
You could use the Sort node and configure it to sort descending on the date field.  Then use a Transform node to filter the records with the maximum date value. The maximum value will be in the first record so you can capture this value in an if statement where the condition is selecting the first ...

RE: Removing spaces from string in column

Posted By Adrian Williams 03-28-2023 09:39
Found In Egroup: Data360 Analyze \ view thread
If you wanted to use a Transform node with some custom code then I would still recommend using the standard Python functions to perform the trimming of the string values. Note you will have to explicitly handle the case where the input data is Null if this can happen with your source data. - ...

RE: Removing spaces from string in column

Posted By Adrian Williams 03-28-2023 09:31
Found In Egroup: Data360 Analyze \ view thread
Rather than creating custom code to perform this task, you could use the Trim node. Given the following test data in a Create Data node: You can configure the Trim node to trim the space characters from the required field as follows: In this case the node is configured to only process ...

RE: Stop overwritten output, keep formatting

Posted By Adrian Williams 03-22-2023 10:39
Found In Library: Data360 Analyze

RE: Stop overwritten output, keep formatting

Posted By Adrian Williams 03-22-2023 10:39
Found In Egroup: Data360 Analyze \ view thread
I cannot reproduce the issue you reported. Here is the example I used to test it out: The source data is from a CSV file: A Modify Fields node is used to auto-detect and convert the data type of the fields. The data is then sent to an Output Excel node that is configured ...