Gerry Mullin
- Total activity 138
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 2
- Subscriptions 58
Comments
Votes on activity by Gerry Mullin Sort by votes-
The logic I went with was using the first table you posted. The idea is to create the new field name as a value first (type1, type2 etc.), then to use Pivot - Data to Names node to pivot those to c...
-
If your Windows Services are not running as the Windows User that you want to authenticate against the SQL Server with, you can also enter the username and password in the DbUser and DbPassword fie...
-
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^}}"
-
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...
-
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. ...
-
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...
-
Attached is an example of how you could standardize the field names to replace spaces with _ and put all field names to uppercase by using a Get Metadata node and a Change Metadata node. Attached...
-
You can use the ls.brain.tempDir parameter to point to some other location. You should see it in your <DSA_Install_Dir>/conf/site.prop file.
-
I've seen that when you delete a parameter, then it appears in purple like you said. Normally wiping out what's in there removes the parameter itself also. In addition to that, try deleting the brp...
-
You can use groupString() in an Agg Ex to achieve that. Here's some sample code. node:Static_Databretype:core::Static Dataeditor:sortkey=5d2cbbff7c960c20output:@40fe6c55598828e5/=prop:StaticData=...