Hi Mark,
thanks for your help.
Yes the attributes are supplied as a list with a 1:M join.
I have used a list exploder as suggested and I can now make a
connection from the meterno{}list to the destination tab file.
However, the tab file still does not display meterno attributes
(visible in FME Viewer though). I have made sure the attributes in
the destination file are correctly defined.
In addition, is it posible not to get a seperate feature per value?
Where there are many meter numbers per source polygon the
destination tab file contains multiple polygons to match. I have
used an Aggregator before the joins with little effect.
Cheers
--- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I expect there are a couple of things to be done.
>
> First - in a 1:M relationship you're probably getting these as a
List
> instead of regular attributes. A list is how FME handles multiple
> values per attribute. A ListExploder will give you a separate
feature
> per value, and is probably what you need to get.
>
> Secondly - the attributes are not perhaps defined in the
destination
> schema. This is relatively simple to fix. Right-click on a
destination
> feature type and choose 'copy attributes from transformer - select
a
> transformer that has the attribute (eg the ListExploder) and they
will
> get added to the destination schema.
>
> The drawback to grabbing attributes from a transformer is that FME
is
> unable to tell the 'type' or 'length' of the attributes, and will
set
> them all to Char20 - so you'll still need to edit the destination
> schema a little bit.
>
> Hope this helps
>
> Mark
>
> Mark Ireland, Senior Product Specialist
> Safe Software Inc. Surrey, BC, CANADA
> [EMAIL PROTECTED] http://www.safe.com
> Solutions for Spatial Data Translation, Distribution and Access
>
> --- In [email protected], "celestelees" <clees@> wrote:
> >
> > Hi all,
> >
> > I have been attempting to derive multiple records from an Oracle
view
> > and display the resulting attributes in a mapinfo tab file.
> >
> > Thus far I have an oracle spatial table with a unique id for
each land
> > parcel which I use in a joiner to obtain attributes from an
oracle
> > view containing water meter numbers, I use 1:M as there can be
up to
> > six water meter numbers for each parcel.
> >
> > In FME viewer I can see a record for each water meter associated
with
> > each parcel but these attributes are not available in the
destination
> > tab file.
> >
> > I have started to look at listbuilder transformers etc but I am
not
> > progressing very fast.
> >
> > Any help appreciated.
> >
>
For insights into what's up at Safe Software and what's on the development
horizon, visit Safe's blog at spatial-etl.blogspot.com.
Safe Software has also made slides available that outline enhancements planned
for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2
of the FME Worldwide Users Conference. To view these slides, visit
www.safe.com/2006uc.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/fme/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
