Old Data coming in through Join

I have a workflow that will be reran each day with new files. On my second day of running this workflow, I noticed my output file contained some data from the previous day. Upon further investigation, it seems this data is somehow being combined with my new data after going through a join tool. Essentially, it looks like data is randomly coming through my join tool. These old IDs that are coming through are not in the new data files. It doesn't appear to be a lot of my data, but it is messing up the reporting output.

I've tried deleting the join tool and input data and remaking that portion of the workflow, but that doesn't seem to be working either. I'm not sure why this would be happening and my searching has come up empty so far, any suggestions on how to fix this?

Input

Join

Accepted answers

domeckn

Want to bump this, I have tried reworking my workflow to get rid of the join, but now the old data is being pulled in at the output. Any suggestions would be welcome, as this issue essentially makes Alteryx useless in this use case.

All comments

Jonathan-Sherman

Hi @domeckn,

Are you sure both inputs into the join are using the new data? Is this a workflow or an app? If it's an app how do you have the action tool configured to update your input tool?

Regards,

Jonathan

domeckn

Hi @Jonathan-Sherman,

Thanks for your reply, this is a workflow and I am inputting new data. I'm sending both my files through a couple tools before going into my join. I've looked through the output of each of these tools and they are only outputting my new data. The first time I notice my old data coming through is at the output of my Join.

As additional context, I am noticing old data coming through my join and right output (I am not using the left output).

Thanks,

Nathan

domeckn

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280