Alteryx returning incorrect values from Excel files

Question

Hello,

I am experiencing something very strange today with Alteryx where it is retuning values different than what is in the Actual Excel file.

This is happening with 3 workflows. One that has been running for quite a while now; a second that is in development and a third that is testing this issue.

There are 2 locations for this file... shared drive and a UAT server. I have ensured there are no variances between these 2 files.

In validating the workflow, I am developing, is where I found a discrepancy between what Alteryx returned and what is actually present in the Excel file... and have now found that within the same workflow to test this issue, Alteryx is returning different values based on the location.

The screenshot is of the workflow testing Alteryx consuming the same file from the 2 different locations.

Alteryx workflow screenshot.jpg

SDJ57 · Answer

@Felipe_Ribeir0, I have experienced issues with OneDrive environment and Alteryx before... but this time it isn't OneDrive

Felipe_Ribeir0 · Answer

Is this shared driver an onedrive/sharepoint shared environment?

I had some problems with the synchronization of files using this type of shared environment, each machine was seeing a different version of the same file, it was terrible.

SDJ57 · Answer

Hi @Luke_C, it is returning different values. I have attached screenshot of a spreadsheet that shows the data returned from Alteryx for the same file found in the 2 locations and the data that is in the file in each location.