List of Contributions

Alex Day

Contact Details

My Content

1 to 8 of 8 total
Posted By Alex Day 03-19-2024 09:34
Found In Egroup: Data360 Analyze
\ view thread
Is there a complete, expanded PDF version of the documentation for Data360 that includes the node help, advanced topics, examples etc? ------------------------------ Alex Day Knowledge Community Shared Account ------------------------------
Posted By Alex Day 02-20-2024 09:10
Found In Egroup: Data360 Analyze
\ view thread
Hi Geoff, I'm sure theres a different way but one solution I've used it to set a default value for the property if its blank and then check for that default value, Example: if ((^PROPERTY_NAME=BLANK^)) == "BLANK": This way if no property is entered, the property reference will default to "BLANK" ...
Posted By Alex Day 08-08-2023 10:13
Found In Egroup: Data360 Analyze
\ view thread
Hi Adrian, Thanks for the help with this, I was able to get the connection working using the connection string properties that point to our alternate keystore ------------------------------ Alex Day Knowledge Community Shared Account ------------------------------
Posted By Alex Day 06-26-2023 13:29
Found In Egroup: Data360 Analyze
\ view thread
Using the HTTP node we are able to input an alternative location and password for a TrustStoreFile if needed. However the JDBC Query node doesn't have this same option. Is there a way to accomplish the same using a JDBC Query node? Our company doesn't allow modifying program files, so we are not ...
Posted By Alex Day 03-30-2023 09:44
Found In Egroup: Data360 Analyze
\ view thread
What options do we have for reading and writing parquet files? I have found a custom solution in an older thread of these message boards that used Java to process parquet files; I have successfully used this method with small parquet files however it seems to have problems with large datasets. I'm ...
Posted By Alex Day 01-31-2023 04:32
Found In Egroup: Data360 Analyze
\ view thread
The transform node is designed to work in a loop already, so simply having one transform node with os.remove() added will delete all of the row separated filepath that you feed into the transform.  Knowing that the transform node loops once for each row of data that you feed into it, your example ...
Posted By Alex Day 01-26-2023 14:46
Found In Egroup: Data360 Analyze
\ view thread
Read the directory using Directory List node Using the date columns from the output of the Directory List node (created or modified date), filter and split out the files that are older than X Then you can link that to a Transform node, and in your Transform you can use this script to loop through ...
Posted By Alex Day 07-08-2022 14:45
Found In Egroup: Data360 Analyze
\ view thread
Is there any way we can read data from an xlsb excel workbook? ------------------------------ Alex Day Knowledge Community Shared Account ------------------------------