List of Contributions

Geoff Goldsmith

Contact Details

My Content

1 to 20 of 50+ total

RE: Change the value of a run property.. at runtime?

Posted By Geoff Goldsmith 05-21-2025 11:25
Found In Egroup: Data360 Analyze \ view thread
trying to make it so i never have to touch it ;) I can do it in a transform and just feed the date i want... its just a pain lol ------------------------------ Geoff Goldsmith Windstream Communications Little Rock AR ------------------------------

RE: Change the value of a run property.. at runtime?

Posted By Geoff Goldsmith 05-21-2025 10:27
Found In Egroup: Data360 Analyze \ view thread
yeah, the variables or tables creates the issue of having to pick it out of the data. Would be nice to have a way to create a high level variable - like the run property, but can be changed and referenced the entire flow without having to pass it along with data :) for now, i will just use the RunDate_FileSafe ...

Change the value of a run property.. at runtime?

Posted By Geoff Goldsmith 05-20-2025 14:02
Found In Egroup: Data360 Analyze \ view thread
is there a way to update/change the value of a run property.. during runtime? like.. node.properties('rundate') = '5/4/202' so late when ((^rundate^)) is used it has that date? thanks! ------------------------------ Geoff Goldsmith Windstream Communications Little Rock AR ----- ...

RE: Upgrade from 3.12 to 3.16 - Deprecated nodes

Posted By Geoff Goldsmith 02-27-2025 08:53
Found In Egroup: Data360 Analyze \ view thread
ahh how funny. Yeah Windstream has evolved a few times over the years :) - As i understand it - the nodes in 3.14+ are the new nodes and just use them going forward, but we can let Adrian 100% confirm that @Adrian Williams ? thank you! ------------------------------ Geoff Goldsmith Windstream ...

RE: Upgrade from 3.12 to 3.16 - Deprecated nodes

Posted By Geoff Goldsmith 02-27-2025 08:19
Found In Egroup: Data360 Analyze \ view thread
this was my concern as well James. I have one flow alone that probably has 50 transforms... Our IT said we needed to change all the nodes to the new ones and that didnt make sense. Precisely has replaced nodes before before and the old ones still worked - i still have some flows with very old nodes still ...

Upgrade from 3.12 to 3.16 - Deprecated nodes

Posted By Geoff Goldsmith 02-26-2025 10:49
Found In Egroup: Data360 Analyze \ view thread
We are updating to 3.16 from 3.12 and I see that in 3.14 there are a ton of deprecated nodes... do we need to replace all those nodes in our flows because they will not work in 3.16? (what I heard..) Is this true? or will they work like previously deprecated nodes... you just have to use the new nodes ...

RE: New Fixed Format node does not work correctly

Posted By Geoff Goldsmith 05-31-2024 12:02
Found In Egroup: Data360 Analyze \ view thread
Great! Thanks Adrian! ------------------------------ Geoff Goldsmith Windstream Communications Little Rock AR ------------------------------

RE: New Fixed Format node does not work correctly

Posted By Geoff Goldsmith 05-31-2024 10:35
Found In Egroup: Data360 Analyze \ view thread
You mean put it all in one line? Sure I could but I dont want to.. if I have to review/change anything its going to be a pain. This should work the same as the old one. No reason it shouldnt... ------------------------------ Geoff Goldsmith Windstream Communications Little Rock AR ----------- ...

New Fixed Format node does not work correctly

Posted By Geoff Goldsmith 05-22-2024 09:27
Found In Egroup: Data360 Analyze \ view thread
I have a flow that has been working fine, but needed a tweak. I noticed that the Fixed Format File node i was using is deprecated .. so I tossed the new one, copied the field list over.. and ran it. Errors. No matter what I do.. this keeps telling me I have too many commas?? I found that if I put ...

Check if property is empty?

Posted By Geoff Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 Goldsmith 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 ------------------------------