09-20-2022 05:40 PM
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. ?
09-21-2022 04:58 AM
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.
09-21-2022 09:36 AM
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
09-21-2022 10:09 AM
If I did option 2, how would I get it to read a row twice to apply two situations to one row?
09-21-2022 10:35 AM
You need some kind of triggering based on the some source value or text or it would be difficult.
09-21-2022 03:00 PM
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?
07-02-2024 12:17 PM
hI both,
i have a similar issue and was looking for a parser rule example to copy my row twice instead of loading it thru separate files.