
Gerry Mullin
- Total activity 111
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 2
- Subscriptions 48
Activity overview
Latest activity by Gerry Mullin-
Gerry Mullin commented,
There is no looping in the example, hence why it should be quicker than using a Do While node in the process. The data flow I provided will only allow one SqlQueryFieldBinding value, not 2 like you...
-
Gerry Mullin commented,
You can name the property UnescapedQuoteHandling, click on the menu to the right and then select Edit Details -> Run Time Property Name = ls.brain.node.csv.unescapedQuoteHandling. Hope that works! ...
-
Gerry Mullin commented,
There's a couple of options that have worked for me: 1. You can manually create the parameter on the node and ensure it has a Run Time Property Name of ls.brain.node.csv.unescapedQuoteHandling You ...
-
Gerry Mullin commented,
I don't understand why you can't use JDBC, as Oracle JDBC Driver is shipped with Analyze. Maybe you experienced some version compatibility or other issue? In any case, if you want to continue with ...
-
Gerry Mullin commented,
I would recommend you consider upgrading, but in the meantime I recreated the solution in 3.4.3. Attached files example.pngJDBC In Condition - v3.4.3.lna
-
Gerry Mullin commented,
Sorry yes, you are correct! I forgot the scenario I described would require a loop for DB Execute. I ran into this issue before and replaced it with JDBC Query. Here's a library node I built for th...
-
Gerry Mullin commented,
You could try changing your query from = to in. Oracle allows you up to 1000 entries for an in condition query, I believe SQL Server has no limit, other databases will probably vary in what they al...
-
Gerry Mullin commented,
You will need to import the certificate(s) from the API you are using into Analyze's cacerts truststore file. It's discussed in the documentation here.
-
Gerry Mullin commented,
Tevita, it looks like you have a lot of Superseded nodes in that data flow, it can be beneficial to replace them. Which leads me onto my next suggestion. Have you tried using the Transpose node? It...
-
Gerry Mullin commented,
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...