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 columns the same
Load 2: Amount- column H, Source - column C, other columns the same
Would I have to import this file twice with 2 of everything...WP, Data sources, etc. ?
It is possible to use rules on data sources to choose which columns to select dynamically. You could potentially utilise that functionality. Otherwise the easy solution is to have two import channels and two different data source definitions.
Couple of Options
- 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.
- 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
So it will take it dynamically for the columns in the DS.