Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
2 years ago

Bulk updating transformation rule

1. I am trying to export as trx for the derivative rule with a business rule in it.

1a. Once it exports, the exported file doesnt have the business rule name in it.

(OR)
2. Exported the rule as xml via application export and then opened it in the excel file as XM table.

However, once i add rows below it and then try to export the file -> It says cannot export.

 

How to insert multiple lines in the excel and get tehm exported as xml for onestream input ?

 

Parsing
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Neither of those options will work with business rules or complex expressions, you'll have to go through the XML exported by Load/Extract screen - which is not in Excel format, unfortunately.

    • OS_Pizza's avatar
      OS_Pizza
      Contributor III
      2 years ago

      JackLacava.  I have to update 250 lines for one group with just different product code. What will you suggest?