Bulk updating transformation rule

OS_Pizza
Contributor III

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 3

JackLacava
Community Manager
Community Manager

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.

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

chul
Contributor III

I built a template - please see attached.

cds