List of Contributions

Geoff Geoff

Contact Details

My Content

1 to 20 of 50+ total

Check if property is empty?

Posted By Geoff Geoff 02-16-2024 10:36
Found In Egroup: Data360 Analyze \ view thread
Is there a way to check if the value of a property is empty in a node? like if ((^PROPERTY_NAME^)) is None: nothing i try works, i just need to set a default value if the prop is blank ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ----------------------- ...

RE: Check field type and Convert to int dynamically in a transform node?

Posted By Geoff Geoff 02-09-2024 09:45
Found In Egroup: Data360 Analyze \ view thread
EXACTLY WHAT I WAS LOOKING FOR! Thank you!! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

Check field type and Convert to int dynamically in a transform node?

Posted By Geoff Geoff 02-08-2024 15:47
Found In Egroup: Data360 Analyze \ view thread
I am trying to read all the fields in and convert them to integer.... i know this isnt right.. but something like this so no matter how many fields you feed in, it will convert them all to integers type i=0 while i < len(inputs[0]): outputs[0][inputs[0][i].name] =str i=i+1 I would also ...

RE: Execute Stored Procedure oddity

Posted By Geoff Geoff 07-12-2023 10:11
Found In Egroup: Data360 Analyze \ view thread
it is Oracle, and I did see the cache was set to one, so I turned off the cache. It STILL did it lol so get this.. for fun, I created a 2nd stored proc. that simply calls the stored proc that I want to run.. In 360 i call that one, and it works. It only increases by one now as it should! So, Im ...

Execute Stored Procedure oddity

Posted By Geoff Geoff 07-11-2023 12:23
Found In Egroup: Data360 Analyze \ view thread
I am baffled... I have a stored proc, that the first thing it does is insert a row into a table (which creates an ID from a sequence) When I run it from D360 the sequence jumps by 20... When I run it in SQL Dev it increases by 1 as it supposed to do. I cannot determine why?? anyone have ANY ...

RE: Excel file wont load into another system unless we open it?

Posted By Geoff Geoff 06-21-2023 08:48
Found In Egroup: Data360 Analyze \ view thread
ahhh so it should get fixed on the next patch hopefully. Thanks! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Excel file wont load into another system unless we open it?

Posted By Geoff Geoff 06-20-2023 09:14
Found In Egroup: Data360 Analyze \ view thread
Tried again using a template that I know loads ok... still doesnt load until I open the excel file and close it again ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Excel file wont load into another system unless we open it?

Posted By Geoff Geoff 06-19-2023 16:01
Found In Egroup: Data360 Analyze \ view thread
3.10.1.3820 ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Excel file wont load into another system unless we open it?

Posted By Geoff Geoff 06-19-2023 09:40
Found In Egroup: Data360 Analyze \ view thread
Currently cant check... our d360 seems to be down. I will get back to you. ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

Excel file wont load into another system unless we open it?

Posted By Geoff Geoff 06-16-2023 09:42
Found In Egroup: Data360 Analyze \ view thread
I am using d360 to create a number of excel files, which we then upload into another system from a 3rd party vendor... the strange thing is, these file will NOT load unless we open the file first, then close it... then they work fine. Any idea? ------------------------------ Geoff Geoff Windstream ...

RE: Output Excel - File Name

Posted By Geoff Geoff 05-05-2023 08:22
Found In Egroup: Data360 Analyze \ view thread
i was asking about the File name, not the field names...Thanks! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Output Excel - File Name

Posted By Geoff Geoff 05-04-2023 10:51
Found In Egroup: Data360 Analyze \ view thread
Done!! Thanks! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Output Excel - File Name

Posted By Geoff Geoff 05-04-2023 10:09
Found In Egroup: Data360 Analyze \ view thread
will this change? the input excel file allows it.. seems odd the output excel does not.. ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

Output Excel - File Name

Posted By Geoff Geoff 05-03-2023 14:08
Found In Egroup: Data360 Analyze \ view thread
the Output to Excel node has an option to use the input fields for a file name, but it doesnt work? but when I try it.. it errors. Unable to create the output file. While the file itself does not need to exist, the path to the file needs to exist and be accessible prior to running the node then gives ...

Convert Row into field names?

Posted By Geoff Geoff 05-03-2023 10:15
Found In Egroup: Data360 Analyze \ view thread
EDIT***** just realized I can not output the header row for excel so row one becomes the header... oops lol :) I know I could take all the fields, list them in a create data and use that with a change metadata but that would mean I would need to monitor the data to see if any new fields appear...soo ...

RE: Stored Proc with return Params?

Posted By Geoff Geoff 04-19-2023 10:17
Found In Egroup: Data360 Analyze \ view thread
got any examples? the sample only shows a create table and drop table... Thanks! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

RE: Nodes Fail without providing additional information

Posted By Geoff Geoff 04-18-2023 16:38
Found In Egroup: Data360 Analyze \ view thread
I had this happen to me... it was a character in the field name that was the issue. Not sure if that helps ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

Stored Proc with return Params?

Posted By Geoff Geoff 04-18-2023 15:33
Found In Egroup: Data360 Analyze \ view thread
How can I call a stored proc that returns 2 parameters? create or replace PROCEDURE     XR_CREATE_MRC_OUTBOUND( OUTBOUNDBATCHID OUT NUMBER, TIMESTAMPCHAR OUT VARCHAR2) Thanks!! ------------------------------ Geoff Geoff Windstream Communications Little Rock AR ------------------------------

Agg - Old vs New

Posted By Geoff Geoff 08-15-2022 15:31
Found In Egroup: Data360 Analyze \ view thread
I am going through and updating an old lavastorm flow that was basically imported and run... I am currently Replacing the AGG nodes and wondering.. the old node was easy in that you could group by a few fields, sum a few and would still spit out all fields... with the new one, you cant. You have to ...

RE: FTP Get file info?

Posted By Geoff Geoff 05-03-2021 06:22
Found In Egroup: Data360 Analyze \ view thread
i assume this means we dont have it installed? Execution Error No module named pysftp