My Excel data is incorrectly read as "00:00:00" instead of "ABC"

Question

Not sure what is happening here, but Select tool keep reading my excel data as "00:00:00" instead of "ABC". Looked in my excel file, data is formatted as string. Select tool recognizes data as string but spits out wrong information.

Can someone please let me know what am I missing here? Thank you

Pardeep · Answer

@binu_acs Sorry for the confusion.. Both files are same, we just create a new workbook every day. So you see the different names.. I also checked the file I am reading in my Alteryx workflow, data is correct in it. When I look for type of data in those columns in Excel, its returns 2 (string value) as answer..

binu_acs · Answer

@Pardeep Can you check the input file again? your screenshot shows the file name as DLB January 09 vf.xlsm but the input file showing DLB - January 11 vf.xlsm

Pardeep · Answer

@binuacs Even the Browse tool is showing wrong data output