The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Load file twice with one upload
Is it possible to load one file twice without creating two separate loads? We want to load one file but with separate columns used in each load. Load 1: Amount- column G, Source - column B, other ...
Couple of Options
Option 1
- Using the 2 different DS and 2 WF Import with WF Channel you can use it. This is simple approach without require any additional code.
Option 2
----------------
- Using Parser rule in DS. You need some kind of identification in the file Example
If SOurce = "1" then
use the COlumn B
ELse Column C
End If
So it will take it dynamically for the columns in the DS.
Thanks
Krishna
If I did option 2, how would I get it to read a row twice to apply two situations to one row?
You need some kind of triggering based on the some source value or text or it would be difficult.
Ok I have option 2 set up but not sure on the triggering...how would I use a trigger to get it to read each row twice? I mean in what area, business rules?