Skip to main content
10000+ Posts
Exposing attributes from parameterised SQLExecutor query

OK, here goes.  I have some data in a SQL Server database but it is stored in an object-oriented fashion which means a normal SQL query doesn't work, I have to pivot data in order to create a traditional tabular view.  Now that in itself wouldn't be a problem, but all data is stored in the same location with each asset class (e.g. door, window etc.) having a different number of attributes, so depending on how I pivot I get the relevant attributes as fields.  All good so far?  OK, so I want to push this data from the source database into the target database (Oracle in this case) and the method for doing this is currently using SQLCreator to create the fields by which I want to pivot (based on the asset class as a parameter) and then SQLExecutor to retrieve the pivoted table, which works, up to a point.  What doesn't work is that the attributes of the output from the SQLExecutor are not exposed, and I can't get them to be exposed without Populate from SQL Query option, which fa

Badge Winners

  • FME Form Advanced Training
    mike_greshhas earned the badge FME Form Advanced Training
  • FME Flow Authoring Training
    lolashas earned the badge FME Flow Authoring Training
  • Welcome Back
    nanothstinehas earned the badge Welcome Back
  • Teacher (Grey)
    lauryn00789has earned the badge Teacher (Grey)
  • Integrate Data with the FME Platform Training
    nwinghas earned the badge Integrate Data with the FME Platform Training
Show all badges

Community Stats

32,431
Posts
123,238
Replies
40,557
Members