List of Contributions

Conditional "DbUrl" & "SqlQuery" values for JDBC Query node

Posted By Dinesh Vel 03-04-2020 12:58
Found In Egroup: Data360 Analyze \ view thread

In one of our "JDBC Query" nodes, we have a need to modify our "DbUrl" connection property based on what environment the workflow is in. I can connect an input into the "JDBC Query" node that has a single one-row column (ie. a single data point) that can calculate the appropriate DbUrl. based on the ...

Conditional Columns

Posted By Dinesh Vel 11-13-2019 11:58
Found In Egroup: Data360 Analyze \ view thread

Is there a way to use the ConfigureFields section in a Transform node to conditionally output specific columns based on record count in the input? For example something like the below? If it's not possible to create conditional columns based on record count, is it possible to output columns conditionally ...

RE: How to conditionally allow one data set to continue through workflow

Posted By Dinesh Vel 11-13-2019 07:06
Found In Egroup: Data360 Analyze \ view thread

In case it helps understand, I've drawn out a similar diagram and have attached it, the green piece is the part I'm having trouble figuring out. I'm not sure if this can be solved with a single node or whether it would be a composite with something more intricate inside.

How to conditionally allow one data set to continue through workflow

Posted By Dinesh Vel 11-13-2019 06:55
Found In Egroup: Data360 Analyze \ view thread

I have a scenario where my data passes through a [Transform A] node with 2 output pins and the pin the data comes through is dependent on the value of an inputted run-time property. At any given time, only one pin would be populated with records, while the other would have zero records. Each pin is connected ...

Floating-point division returning incorrect values

Posted By Dinesh Vel 09-19-2019 09:10
Found In Egroup: Data360 Analyze \ view thread

I'm experiencing an issue when dividing decimal values where the returned value is a value that's very close to the intended value but not correct. For example, if you check the attached screenshot, the first 2 rows return values that end in trailing .9s when they should have clean answers (like the ...

Best Practices to Optimize Workflow Editing Speed

Posted By Dinesh Vel 08-06-2019 06:39
Found In Egroup: Data360 Analyze \ view thread

Hi, Currently I notice large periods of latency when a I'm editing a workflow with a large number of nodes in it. To give an example, in one of the biggest files I have, it can take 10 minutes (sometimes longer) to simply disconnect a connection to a node and re-connect it to a different existing ...

Python Substitues for Brainscript (inputFields, field)

Posted By Dinesh Vel 07-26-2019 12:06
Found In Egroup: Data360 Analyze \ view thread

Hi, I'm currently trying to migrate an existing file initially written in Brainscript into Python-based nodes and am having some trouble finding an appropriate analogue to 2 specific functions: "inputFields" and "field". Is there an easy way to use these functions in Python that I'm overlooking? ...

RE: Carriage Returns in Documentation/Tool Tips

Posted By Dinesh Vel 06-27-2019 10:22
Found In Egroup: Data360 Analyze \ view thread

Excellent, thanks Adrian, I also appreciate you sending that documentation so thank you for that as well!

Carriage Returns in Documentation/Tool Tips

Posted By Dinesh Vel 06-27-2019 05:21
Found In Egroup: Data360 Analyze \ view thread

I've noticed when creating a new property there's the option to write in the "Documentation" section which the user can use by hovering over the Property name to reveal a tool-tip. I've started using this functionality as it's a really useful way to convey instruction. However I've been having a hard ...

RE: Variable Excel Output Path

Posted By Dinesh Vel 06-27-2019 05:11
Found In Egroup: Data360 Analyze \ view thread

Thanks Adrian, I think this is definitely a good workaround for what I'm trying to do!

Variable Excel Output Path

Posted By Dinesh Vel 06-25-2019 11:00
Found In Egroup: Data360 Analyze \ view thread

I noticed using the Input Excel node there's the ability to pick-up an Input by either explicitly defining the file to pick-up, or to use the FilenameExpr which allows you to define an expression to use to pick-up the input file. This is really convenient since it allows me to conditionally define a ...

Dinesh Vel

Contact Details