Skip to Content
0
Aug 14, 2022 at 05:53 AM

How to combine through union some diemsions when combining data sources in SAC?

614 Views

Hi,

Lets say I have two data sources im importing into SAC.
Both have a shared list of G/Ls.
Each GL has several journal entries associatred with it in both data sources but the journal entries are not identical between the two data sources.
One data source has a gl 10010 with 3 journal entires, 10001,10002,10003.
The second data source has the same gl, 10010 but three other journal entires, 20001,10002,10003 associated with the G/L.
What I need to do is to combine the two data sources so I get the same G/L list but for each GL add the different journal entries from both data sources.

Thanks.