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 ...
Forum Discussion
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?