Brendan Peterson
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forums
Blogs
Events
Security Advisories
Public Notices
Articles
Downloads
Gallery
Store
Everything posted by Brendan Peterson
-
Since this is a Hierarchical connector you may need to go to the Include tab in order to add the objects to scope that you want to use - once you include them you can use your Create or Build with block to see all one to one related objects or add blocks for one to many. Brendan
-
You mean you want the failed records, not just the execution history IE the right hand side of the screen shot below
-
Here is a pretty basic example where I used MySQL but the map should be pretty much the same. Brendan
-
Query Block: Method to get last run datetime of map
Brendan Peterson replied to Manoj Chaurasia's topic in Cloud Integration
You could take a different approach - if you use "something" as a query to step into your map, you could then use the Scribe API Connector to pull back the LastRunTime of the map you are currently in, and pass that into a Fetch Block as a filter parameter. That should give you what you need with a slightly different pattern to get there. Brendan -
ISERROR is the best way. It will return TRUE if it is #NULL! and FALSE if its not. So it would look like IF(ISERROR(S22), S1, S22& S23) That will check is S22 is #NULL! and if it is, use S1. If its not, it will concatenate S22 and S23... Posted by Brendan P. on May 12 2009 6:48PM { U40 , C1465 }
