Gerry Mullin
- Total activity 138
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 2
- Subscriptions 58
Comments
Recent activity by Gerry Mullin Sort by recent activity-
I think the key here is to identify the data in groups so that from there you can use the functions firstInGroup (or lastInGroup if the order was reversed) to identify the sub type. Here's an attem...
-
The Aggregate you're using is probably grouped by the CUSTOMER_ID but your order dates might not be in order? I would sort the data by CUSTOMER_ID and OrderDate, then group it by CUSTOMER_ID so you...
-
Hi Nithya, I couldn't find an example of somebody having previously pulled data from Neo4j internally. Don and I were trying to get it to work yesterday with the JDBC driver they provide. We'll con...
-
The ability to substring a string in Python is available to you. e.g.. c = in1.Code out1.Flag = 1 if c[:1] == '1' and c[3:4] == '2' else 2 if c[:1] == '2' and c[3:6] == '221' else Null https://...
-
If you know you'll only have 2 rows in each group then it shouldn't be too hard to clean it up like that, using node.firstInGroup and node.lastInGroup functions. Have a look at the LNA attached. ...
-
I deleted my first reply to replace with this data flow. It gives 3 different options to check if a web page exists: 1. Using subprocess module - it will execute a curl command and give the resul...
-
Hi Brad, I guess you still have a problem with DB Query nodes? Let me send you an email and we can work through it.
-
Its now in a drop down menu. By default it goes to Data (from Filename). Click on it to change the option to Data (from Filename Field).
-
If I understand the above right, you want the Aggregate node to run on either: 1. There's no new file found today, so we will just process a common file we have saved somewhere. 2. There is a fil...
-
You don't need to use the 'Use DbName' in the node. You should have that specified in your connection details. Then to reference your fields on the input pin you specify them in the SqlQueryFieldBi...