Can you share a screenshot of the derivative rule that you have already created for the below scenario ?
- When in the file there is a text value in the segment 6 column it is duplicated into an extra line with flow F99_input.
Based on that i can recommend the addition rule that you can create.
This is the derivative rule that is used as derivative (target) in the transformation rule. Whenever it finds an F40 then it duplicates the line with an F99_input. The amount although needs to be either positive or negative based on the account number.
I suppose you dont have to create multiple derivative rule , that will add up extra maintenance whenever you have new segment6.
Let me know if the below rule works. You just have to create these 2 rules -
If it helped , Please give kudos and mark the answer as accepted solution
Thank you for the quick response. It is not completely fixed yet.
Hopefully above screenshot explains a bit more. Line 3 and 4 are part of the source file that we load, only two lines for now.
Line 9,10 and 11 should then be created after transformation. One line should then be created from the derivative rule as there is an F40 in column Segment6. This should be line10 in the screenshot. Line 9 is already has a sign change based on the account nr. and transformation rule for account which starts with a 2. Line 11 does not have a sign change as this starts with a 1, also coming from transformation rules for accounts.
Line 10 which should be created from the derivative should then be duplicated but with a sign change as this is an account starting with 2.
If i make the changes you proposed I get below from only the two files that i load.
