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 Basic Training
    isablukehas earned the badge FME Form Basic Training
  • Welcome Back
    abiramihas earned the badge Welcome Back
  • Teacher (Grey)
    927474939has earned the badge Teacher (Grey)
  • Welcome Back
    ciarabhas earned the badge Welcome Back
  • FME Form Basic Training
    michaelbent22has earned the badge FME Form Basic Training
Show all badges

Community Stats

32,334
Posts
122,971
Replies
40,408
Members