SAP Tables / Join Stuck at 25%

Question

I am working to connect multiple SAP tables, and I am running into an issue when trying to join LIKP to the prior join of the SAP actuals and VTTK table. The join tool will not load past 25%-I gave the report 2 hours to attempt to process and it still did not complete.

I am looking on advice if the current WF is the proper way to join multiple tables. In addition, what would be causing the join to not complete?

25% join.PNG

sap tables wf.PNG

Simon_Theobald_SW · Answer

Hi, if you couldn't find a solution to this problem, you can also check out Xtract for Alteryx as SAP connector in a free trial. It supports joining (multiple) tables during the extraction process. The join is performed in SAP and only result set delivered to Alteryx which makes it very efficient. It is available here:  https://theobald-software.com/en/xtract-for-alteryx/

cjaneczko · Answer

Remove the join and see if are getting data to the input anchors. Its likely not the join tool but the DB connection before it.