magnify
Home Topic Xlone report maintenance

Xlone report maintenance

Home Forums Miscellaneous Xlone report maintenance

This topic contains 0 replies, has 1 voice, and was last updated by  Penny Hamlett 2 years, 10 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #797

    Penny Hamlett
    Participant

    I am part way through building an ETL to check excel files against F1 functions and files in the T1 custom reports directory to assist with a major tidy up of duplicated functions, missing file links, old report versions no longer linked to a function etc. One step in the ETL is to get the file settings associated with F1 XLone functions. I have been playing and am feeling pretty pleased with myself to have worked out how to write the following SQL so just have to share it. This can be run via ISQL for those that don’t have full ETL. Watch this space for the full solution when I have put the rest of the pieces of the puzzle together.

    SELECT func_Name,StartWorkbookDirCode,startworkbook,startworksheet
    FROM (SELECT func_Name,attribute_name,attribute_value1 From TBFUN_FUNC_STGS WHERE LEFT(FUNC_NAME,1)<>’$’ and source_type_ID in (‘9E0C3DCC’,’C3016B5D’)) sq
    PIVOT
    (max(attribute_value1)
    FOR attribute_name IN (StartWorkbookDirCode,startworkbook,startworksheet)
    ) AS pt
    order by startworkbook,startworksheet,startworkbookdircode

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.