03-30-2023 02:57 PM
I'm loading a Fixed Width data file to Stage for Transaction matching.
This file has:
Goal - Load the DATE from header record on every detail record.
Sample File
HDR01122023
DTL0088351000000572975A000000018
DTL0088351000000123456A000000018
TRL000000
What I want to load into OneStream
Record_1:
Date: 01122023
Tran Type: 100
Amount: 572975
Record_2:
Date: 01122023
Tran Type: 100
Amount: 123456
Solved! Go to Solution.
03-31-2023 09:55 AM
One technique for this sort of thing. is to set a Business Rule on the Amount dimension, so it runs on every line. When it finds the "date" line, it stores the value in the Globals object. Then, another rule assigned to Time simply retrieves and returns that value.
03-31-2023 09:55 AM
One technique for this sort of thing. is to set a Business Rule on the Amount dimension, so it runs on every line. When it finds the "date" line, it stores the value in the Globals object. Then, another rule assigned to Time simply retrieves and returns that value.
04-03-2023 09:20 AM
Thank you Jack. That's exactly what I needed.