I have 2 Datasource imports that I want to use the same mapping tables. The first workflow is an actual monthly GL load. The datasource is a comma delimited file and uses 2 different columns to determine the source value for the UD1 dimension. The se...
G'day ONE members, There are blanks for some rows in certain Dimensions in our source data files.1. In DS w/o using a Logical Operator, pls share how to map those blanks to new values, and/or2. In TR, please share how to map those blanks to new value...
Hello, I was wondering if there's a way to dynamically load a flat file once per year for a specific month. We load data yearly for our CapEx Budget and was wondering if you can assign a static value such as |WFYear|M1? I tried it but failed so right...
Hi All - explored other threads but could not find the right answer. Unsure if this should be one or two mappings and what type if they are a conditional rule or composite? If value at SourceAccount MAIN has a value of 1, then: Source should be Sourc...
Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I a...
