Hi everybody!
I’m pretty new to celonis development and never ask a question here before, but I hope you can help me!
I’m extracting data from SAP for Production data and now have the issue that I want to join the JEST table to two other tables (AUFK and AFVC) on the column AUFK.OBJNR and AFVC.OBJNR. How can I do that since downloading the whole JEST table means like 200 million entries :-(
I hope you can help me!
Thank you very much!
Best answer by victor.diens
Hi
I’m trying to do the join before they are present in celonis.
I’m trying an idea whre I first download the Tables AUFK and AFVC in the first extraction step an then add two more Extraction steps and there configure the Join Configuration:
Then I create a UNION and safe everything to a table JEST.
I hope this will do what I want…
Or is there maybe a better way?
If you have already downloaded the table you could create a new view on the original table.
i.e.
CREATE or REPLACE VIEW "JEST_VIEW" AS
SELECT *
FROM “JEST”
;
Or are you asking if you can do a join on data that isn’t present in Celonis?
br Florian
Hi
I’m trying to do the join before they are present in celonis.
I’m trying an idea whre I first download the Tables AUFK and AFVC in the first extraction step an then add two more Extraction steps and there configure the Join Configuration:
Then I create a UNION and safe everything to a table JEST.
I hope this will do what I want…
Or is there maybe a better way?
I never had to use a join like this in an extraction so I can’t tell if there is a better way. You probably don’t have to download the AUFK and AFVC tables first to define a join. I assume you can reference the tables in the SAP database. But I’m just guessing. Pretty sure someone else can answer this better than me.
Good luck!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.