Alteryx is pulling a wrong value

[Jivka]

Hi all,

I hope that you can help me with the following problem that I'm facing:

I have two flows that are using the same file/s

the first flow is inserting values in one of the sheets /Let's call it A/ and the second flow is reading values from another sheet /B/.

Sheet B has formulas connected to sheet A.

When the second flow is trying to pull the data from sheet B however, some of the numbers are not ok. 

/I'm checking the numbers in the Input tool, without any modifications/

I'll show example of one specific cell with one number:

 

 -- this is a really huge number, below is the correct one.

If I open the excel myself - everything seems ok - the numbers are right and are not the ones that Alteryx is showing.

If I manually save the file after I've opened it and rerun the second Alteryx flow - This time the numbers that the flow is showing are ok.

I hope that someone can help with the answers to those questions:

What might be the problem and how can we fix that? Also opening and resaving all of the files is not really optimal since the files are really a lot. Also - why is this happening only with SOME of the values?

Thanks in advance,

Jivka

[TheOC]

Hi @Jivka 
Can you please attach one of the excel files with the problem records - even if its just one of the records in the excel document, so i can troubleshoot this problem exactly?

Thanks,
TheOC

[Jivka]

Hi @TheOC,

Unfortunately there is no way for me to share such a file, since the data inside is confidential and if I cut the data to only 1 row - that means resaving the file .... and the initial problem is resolved. 

Regards,
Jivka

[Samanthaj_hughes]

Hey there, based on the detail you have supplied, can you check your data types of your excel and in Alteryx. It looks like you are concatenation data where that column/row may exist more than once, so its tagging all the data into a list.

Is this the intended behaviour?

If not perhaps change your data types and what you are trying to do in the Summerise tool.

Perhaps a screenshot with someone might help see the problem with this one a bit quicker in the situation.