Forum Discussion

RonnieKarpinsk's avatar
RonnieKarpinsk
New Contributor III
4 years ago

Transformation Rules

Is there a way to export the Transformation Rules into an Excel file? 

  • You can export the selected transformation rule as csv (even if it is called trx) if you click on this icon:

     

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor

    Hi Ronnie: you can extract using the standard Application Load/Extract tool > Select Transformation Rules > the Group(s) you want > and then open the resulting XML file in Excel > As an XML Table. It formats in a standard looking table that you can review/filter from there.

     

    • CarmenBrower's avatar
      CarmenBrower
      New Contributor II

      This was great help. Especially to convert to xml table. Thanks!

  • ChristianW's avatar
    ChristianW
    Valued Contributor

    You can export the selected transformation rule as csv (even if it is called trx) if you click on this icon:

     

     

  • ChristianW's avatar
    ChristianW
    Valued Contributor

    Great to help you, can you mark it as a solution? It helps others with similar questions. Thanks

    • CarmenBrower's avatar
      CarmenBrower
      New Contributor II

      Hi Christian, not sure how to mark as as a solution. 

      • ChristianW's avatar
        ChristianW
        Valued Contributor

        you can't only Ronnie can, he should have a button for it: