List of Contributions

clef andrin

Contact Details

My Content

1 to 13 of 13 total

RE: How to write a field value into a Message Body and Subject of an Email node.

Posted By clef andrin 11-28-2024 11:43
Found In Egroup: Data360 Analyze \ view thread
Thanks a lot, Adrian. At first it was not working, then I deleted the input pin on the email node, and it works fine. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

RE: How to write a field value into a Message Body and Subject of an Email node.

Posted By clef andrin 11-28-2024 10:13
Found In Egroup: Data360 Analyze \ view thread
Hi Adrian, Thank you very much. Your solution is very straightforward. I was able to make it work on my case. But when there is no data fetched, it does not send any email. I want it to also send something like "Defect Cleanup Notification - 0 Problems Found." My data is coming from a DB query node. ...

How to Create E-mail Body

Posted By clef andrin 11-27-2024 10:34
Found In Egroup: Data360 Analyze \ view thread
What node to use in creating an email body before actually calling the Send Email node? ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

How to write a field value into a Message Body and Subject of an Email node.

Posted By clef andrin 11-27-2024 09:26
Found In Egroup: Data360 Analyze \ view thread
I'm fairly new to D360 and would like to achieve something like this. Appreciate anyone to give insight. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

RE: Proper Syntax to call Oracle Stored Procedure using DB Execute

Posted By clef andrin 10-17-2023 12:09
Found In Egroup: Data360 Analyze \ view thread
Thank you, Peter. It works. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

Proper Syntax to call Oracle Stored Procedure using DB Execute

Posted By clef andrin 10-16-2023 09:34
Found In Egroup: Data360 Analyze \ view thread
Hi, how can I properly call the oracle stored procedure using DB execute node? I already tried 'EXEC Schema.PROC', 'EXECUTE Schema.PROC', 'BEGIN Schema.PROC END' but none works. Appreciate the help in advance. ------------------------------ clef andrin Knowledge Community Shared Account ---------- ...

RE: Execute Stored Procedure oddity

Posted By clef andrin 10-16-2023 09:22
Found In Egroup: Data360 Analyze \ view thread
Hi Geoff, how do you call the stored proc in D360? ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

RE: Number Stored as Text Error in Inserting Data in Excel

Posted By clef andrin 10-10-2023 12:41
Found In Egroup: Data360 Analyze \ view thread
Thank you very much. It works now. Appreciate the help. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

Number Stored as Text Error in Inserting Data in Excel

Posted By clef andrin 10-09-2023 10:19
Found In Egroup: Data360 Analyze \ view thread
I have list of data that needs to be inserted on an excel file. Some of the columns are number, I already handle the conversion to type long of this columns, but when the data was inserted on the excel file I'm getting the error "Number stored as Text" on. Do we have fix for this? Appreciate your ...

RE: auto deleting file by

Posted By clef andrin 08-21-2023 10:02
Found In Egroup: Data360 Analyze \ view thread
This helps me in one of our project requirements. Thank you very much for sharing. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

Delete excel file from specific path after each run of the data flow.

Posted By clef andrin 08-21-2023 09:06
Found In Egroup: Data360 Analyze \ view thread
Hello, I'm exploring how to delete a file from a path after each run of the data flow. Can someone guide me on this? Thank you in advance. ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------

Use specific value from a certain column and use that as a value for the entire new column

Posted By clef andrin 08-17-2023 12:18
Found In Egroup: Data360 Analyze \ view thread
I want to use a specific value from a column and use it as a value for the entire new column. Is this possible? I want to achieve something like this. Col1 Col2 Col3(new column) Col4 (new column) 21 NULL 21 378.05 NULL 378.05 21 378.05 ------------------------------ clef andrin Knowledge ...

Create new field based on the value of a specific field

Posted By clef andrin 06-12-2023 10:18
Found In Egroup: LAE \ view thread
How can I implement this script to updated transform node? if firstExec then C2 = null if C1.isNotNull() then C2=C1 emit * emit C2 ------------------------------ clef andrin Knowledge Community Shared Account ------------------------------