Skip to main content
Apr 6, 2023 7:54 AM UTC

Bulk updating transformation rule

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

OS_Pizza_0-1680767340656.png

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

OS_Pizza_1-1680767459345.png

(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.

OS_Pizza_0-1680770214363.png

OS_Pizza_1-1680770242078.png

 

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

 

3 replies

Employee - Sage
Apr 6, 2023 9:22 AM UTC

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_PizzaAuthor
Apr 6, 2023 9:39 AM UTC

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

Employee - Guide
Apr 7, 2023 6:05 PM UTC

I built a template - please see attached.