Skip to main content
Archived

DatabaseJoiner - extension of B.Table field behavior

Related products:Transformers
  • September 8, 2017
  • 0 replies
  • 32 views
scyphers
Participant
Forum|alt.badge.img+5

I am playing with a series chained of DatabaseJoiners which receive a recordset of parcels and i would like to join the 'failed unjoined' again to the same table using a Substring of the Key.

e.g. where APN = PARCEL_NUMBER fails try

APN_sub = @Substring(@Value(PARCEL_NUMBER),0,10)

The text editor on the TableField side of the join does not allow normal attribute manipulation FMEness to happen. Can this B.Table.Key side be extended to do @Value field trickery? I would very much like to only read the records i want from the database, this will require more than normal field Selections.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,749
Posts
124,193
Replies
41,251
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.