List of Contributions

Henrik Borg

Contact Details

My Content

1 to 20 of 45 total

RE: Send email when Filter output finds data

Posted By Henrik Borg 05-06-2025 09:07
Found In Egroup: Data360 Analyze \ view thread
Hi, you could do a regular expression with a transform node, create two outputs for the node. Assume output 1 give you, the result you want(the name you are looking for), And output 2 is the other one. You could connect output one to a meta check, that triggers a mail node if the value is >0 from your ...

RE: Node Limit on Server

Posted By Henrik Borg 04-01-2025 07:32
Found In Egroup: Data360 Analyze \ view thread
Also operations like bigger joins,sorts , aggregations could be done in your source database to elevate the Data 360 server computation? Best regards ------------------------------ Henrik B E.ON Sverige ------------------------------

RE: Node Limit on Server

Posted By Henrik Borg 04-01-2025 07:22
Found In Egroup: Data360 Analyze \ view thread
Hi, couldn't it be an option to increase "JvmMaxHeapSize " that is default 2048mb in " /conf/cust.prop" that affects Java-based nodes. As i see it, you can utilize more of the Server's RAM, configuring this. And this could elevate the strain on the CPU? I have tested this and it seems to run smoother ...

Capturing changes with a trigger

Posted By Henrik Borg 01-14-2025 09:59
Found In Egroup: Data360 Analyze \ view thread
Hi, assume i have the following problem: I have a sharepoint directory, containing excel files. I want to capture the changes in the directory, as in files being removed, added, files changing in size. And after that i want to upload it to an ADLS with the Analyze nodes(Sharepoint and ADLS nodes). ...

Datalake nodes question

Posted By Henrik Borg 12-06-2024 01:57
Found In Egroup: Data360 Analyze \ view thread
Hello, I'm wondering about the Datalake nodes within Analyze, what kind of protocol/api is being used in the background when i use the nodes, let's say uploading/downloading a file to an ADLS? Is it Azure Data Lake Storage Gen2 REST API? Best regards Henrik ------------------------------ ...

RE: Download SharePoint Node

Posted By Henrik Borg 11-12-2024 01:51
Found In Egroup: Data360 Analyze \ view thread
Are you still facing problems with this? Best regards ------------------------------ Henrik B E.ON Sverige ------------------------------

API node, bypass SSL certificate handshake

Posted By Henrik Borg 10-01-2024 04:49
Found In Egroup: Data360 Analyze \ view thread
Hi while using the http node to a specific site im getting the error: failed with network error: Network error occurred while making HTTP request to 'https:…….:' Exception Class: javax.net.ssl.SSLHandshakeException Message: None of the loaded truststores trust this certificate chain When making ...

Sharepoint 365 Download node

Posted By Henrik Borg 09-23-2024 07:16
Found In Egroup: Data360 Analyze \ view thread
Hello, i am using the Sharepoint 365 download node. I can download a file from Sharepoint, to a staging directory and then upload it into Sharepoint again. Assume it's an excel file i want to download from Sharepoint, would it be possible to just read in the data from the excel file into Data ...

Incomplete Time Series

Posted By Henrik Borg 06-18-2024 05:43
Found In Egroup: Data360 Analyze \ view thread
Hello, i have the following problem: Assume i have the data set below, i would like to get a complete timeseries for the data coming in, so 12 more rows of data. Sometimes my time series in hours comes in incomplete. Is it possible to fill the time series for a specific day ? It could just be ...

RE: Row Hash optimization, Data comparison/validation test

Posted By Henrik Borg 05-30-2024 04:56
Found In Egroup: Data360 Analyze \ view thread
Thanks for the help Adrian, the solution works. I did a test with 3 different data sets(rows > 10^6), it turned out that my solution i first posted was 18.2% faster than your version(i took a mean of the 3 test). ------------------------------ Henrik B E.ON Sverige --------------------------- ...

RE: Row Hash optimization, Data comparison/validation test

Posted By Henrik Borg 05-30-2024 02:20
Found In Egroup: Data360 Analyze \ view thread
Thanks for the answer Adrian. The problem with the new script compared to the old is that, i dont get unique values for the Rowhash output, all values are the same. In the old script, i get unique values for each row, for RowHash in my test dataset. Modified script: ------------------------------ ...

Row Hash optimization, Data comparison/validation test

Posted By Henrik Borg 05-29-2024 04:58
Found In Egroup: Data360 Analyze \ view thread
Hello, this is a great solution im using to generate a hash value for an entire row with N number of columns and N amount of data. I use this for data comparison/Data validation test to see if two datasets are exactly the same, so i just run two datasets into the transform node below and then i make ...

RE: Create a Temporary List or Set in Transform Node

Posted By Henrik Borg 04-22-2024 04:38
Found In Egroup: Data360 Analyze \ view thread
Hi, for me it would be a lot easier to understand. If you send pictures of a sample data input, and expected output. Like below: ------------------------------ Henrik B E.ON Sverige ------------------------------

concatenating N amount of columns and values comma separated

Posted By Henrik Borg 04-22-2024 03:55
Found In Egroup: Data360 Analyze \ view thread
Hello, assume we have the input data as per below: Image 1 Assume i want the input data represented as an output as below: Image 2 Would this be possible to do for N amount of columns and N amount of data values, making it a generic solution without hardcoding each column name? It ...

RE: Data Flows that are "Locked for Editing"

Posted By Henrik Borg 04-08-2024 05:15
Found In Egroup: Data360 Analyze \ view thread
Hi, as far as i know you need to be signed in as an admin user and do the following: ------------------------------ Henrik B E.ON Sverige ------------------------------

Batch insert query optimization

Posted By Henrik Borg 03-22-2024 06:39
Found In Egroup: Data360 Analyze \ view thread
Hello, i want to use the dbexecute and not the db store node to do a batch insert of rows. So assume the following scenario: In this case i only have two rows, i want to make into one single insert statement as per below: This method is very costly, if i want to insert a big number of rows, especially ...

Calculate Fields Node

Posted By Henrik Borg 02-22-2024 01:24
Found In Egroup: Data360 Analyze \ view thread
Hello everyone, a quick question. Do i always have to create new output columns while i use calculate fields, it would be nice to use it for conditionals? As an example, would it be possible to replicate the following from a transform node in Calculate fields, to have a conditional without creating ...

RE: Field name with spaces

Posted By Henrik Borg 02-05-2024 04:29
Found In Egroup: Data360 Analyze \ view thread
Hm i would change the name in modify fields, adding a space. Or you can maybe do it from a select query, select column1 as column 1 maybe ------------------------------ Henrik B E.ON Sverige ------------------------------

RE: How to Sum 3 column value but can contain NULL

Posted By Henrik Borg 01-22-2024 01:45
Found In Egroup: Data360 Analyze \ view thread
Can't you replace the nulls' with zeroes? so it becomes a valid object to perform int operations on? And if you want to perform string operations i would replace the null's with an empty string. ------------------------------ Henrik B E.ON Sverige ------------------------------

RE: Date to date delta count for time series

Posted By Henrik Borg 10-11-2023 02:15
Found In Egroup: Data360 Analyze \ view thread
I found that one solution is, solving the logic with SQL and then extracting that to a D360 Workflow. ------------------------------ Henrik B E.ON Sverige ------------------------------