Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago

I have a file with two amount columns that I need each amount to go to different flow members

Originally posted by Jon Golembiewski 3/11/2020 Got a data source puzzler - I have a file with two amount columns that I need each amount to go to different flow members. The first amount will al...
Data Sources
OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago
Originally posted by Puja Patel

This might be a long winded way. But keeping with the matrix data source:

1. Amnt in LOC Crcy --> (Static Value of EUR in Data Source) - Matrix DataKey for Flow Source Dimension

2. Amnt in DOC Crcy --> (Static Value of [RandomMember] in Data Source) - Matrix DataKey for Flow Source Dimension

3. Document currency --> assign to an enabled Attribute (e.g. A1)

In transformation rules,

1. Use composite mappings - e.g. A1#AED:F#[RandomMember] maps to Target F#AED

2. Can use a passthru mask rule of * to * for your Amnt in LOC Crcy mappings.