Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Blending Using Access

soumya
7 - Meteor

I have my data for a particlaur month divided in 2 different access databases. Both the Access Databases have the excat same fields and I am using the uniron function to connect the 2 databases and then use a summarize function to get the media cost but it's doubling up the numbers. How can I fix this issue? 

1 REPLY 1
jdunkerley79
ACE Emeritus
ACE Emeritus

I am guessing there is some duplication in the data.

 

I would suggest you use a unique tool after the union tool to pick out a unique set of data.

Labels