Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Getting duplicates while extracting data while using "Xtract Universal" tool

Highlighted
Atom

Hello,

 

We are using "Xtract Unvirsal Tool " to fetch data from SAP. When we are pull bulk load, we are getting duplicates, we have checked the same with primary key in SAP but we don't have duplicates in SAP.

 

Please check snapshot. Please let me know if you need more details to resolve this issue.

 

(Without moving data database only we are finding duplicates i.e., we are missing unique values in that place)

RPattle_0-1580125789775.jpeg

RPattle_1-1580125814018.jpeg

RPattle_2-1580125821382.jpeg

 

Regards,

Ramya.

Highlighted
Alteryx Partner

Not sure, it looks like your where clause is good. Might want to reach out to Theobald https://theobald-software.com/en/alteryx/ so they can take a look at that Macro. Were you able to run successfully before? 

 

Highlighted
Atom

Hello Joshua,

 

Thank you for your reply. Yes we are able to run successfully for small data sets, we are not getting any duplicates but for huge data we are getting duplicates. 

 I'll to reach from support form Theobald.

 

Regards,

Ramya.

Labels