Skip to main content

We are working on one use case here, we have two systems one is SAP & other is readsoft workflow. when ever an invoices is processed then that invoice will enter into SAP from readsoft means SAP BSEG table consists of the processed invoices and readsoft table consists of both processed and non processed invoices. where in the data model we are taking BSEG table as a case table and joining with readsoft table. when we load the data model we are able to see only processed invoices in the studio but unable to see the non processed invoices from the readsoft table.

could anyone you please help us how can we get those non processed invoices into stuido.

Hi,

 

If the two are not the same (column names, number etc.) you won't be able to perform full outer join.

Even if you will have a full Readsoft table loaded into data model, it will be filtered by BSEG Case table.

 

The only solution to have all invoices (Processed and non-processed) is to having Readsoft table set as a case table in place of BSEG, or try to use multi-eventlog.

 

Best Regards,

Mateusz Dudek


Reply