Complex Expression on Matrix Data Load
I have a complex expression on the amount field in a data source used to convert any non-local currencies to the local currency (see below). That complex expression currently runs on tabular data wit...
Forum Discussion
Thanks for the suggestion. It doesn't look like the data is converted at this stage of the process. Below is an example of how the args.line looks. It's one row of data with the amounts in 25 different fields.
I may look into converting the data source to tabular but first wanted to see what other options exist to handle this for a matrix load.
| 10105,ACP001501,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5 |
On Matrix loads, expressions are evaluated once per file if put on the individual dimension element, and every time if set on Amount.
If you're just trying to determine which period each column is, try looking at this thread: https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Unable-to-get-value-from-another-column-in-Parser-BR/m-p/19099/highlight/true#M1340
Also look at the properties of the api object, there are a few matrix-specific fields you might want to check out.