Gerry Mullin
- Total activity 77
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 1
- Subscriptions 37
Activity overview
Latest activity by Gerry Mullin-
Gerry Mullin commented,
This might not be the most intuitive data flow but hopefully it more or less achieves what you need. What it does: 1. If CurrentMonth exists on the input Excel file, then we will read that sheet,...
-
Gerry Mullin commented,
What output node are you using? If it's "Output CSV/Delimited" then you can take the file name from a field on the input pin by selecting Filename (from Field) in the drop down in the Output sectio...
-
Gerry Mullin commented,
If you create a field called RecordID on one of the data sets you can then use a histogram directly after your Merge or Join node and count up how many times it is there. If it is not unique it wil...
-
Gerry Mullin commented,
I've re-read this a couple of times and I don't think I fully understand the ask so I hope I give you something to think about at least. I do see a request to have a partial match within the Merge ...
-
Gerry Mullin commented,
A couple of things. I noticed yesterday you had an extra ^ in the parameter value (3 rather than 2). I think with 3 it will only take the default value so make sure it is like this (no quotes also)...
-
Gerry Mullin commented,
If you put an = after the parameter name but still inside the brackets it will take that value as the default when the parameter has not been given any value. e.g. FN="{{^FolderName=MyDefaultValue^}}"
-
Gerry Mullin commented,
When you say you are using pipe delimited txt files, am I right in presuming you are writing out the data using Output CSV/Delimited node? If so there is a Field Order section in that node where yo...
-
Gerry Mullin commented,
Hi Josh, like you I can't seem to get the CSV node to write out a file when it has 0 records. We're looking into it. In the meantime I believe the data flow here will get you where you need to be. ...
-
Gerry Mullin commented,
Just backing up what Adrian has said above with a link from stack overflow. Date stores to nearest second, Timestamp is for millisecond. It's discussed here.
-
Gerry Mullin commented,
Maybe this data flow would be a little easier? We can just add one dummy record to ensure you always get 1 into the final Transform node and when we count up how many records we had we will do (nod...