community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Excel Values Truncated in Alteryx

Hi,

 

I am trying to import an excel workbook in Alteryx. This workbook has 2 columns with SQL Queries (long string value).

 

When I use the Macro input to get this file in Alteryx the value of the queries gets truncated and has some weird values _x000d__.

 

Attached is the file I am using. Please advise.

Alteryx
Alteryx

Hello,

 

Alteryx by default will only show you the first 1MB of data, which is why it is saying it has been truncated.  If you add a browse tool you will be able to see all the data in the given cell using the cell viewer.

 

I also tested exporting it back into Excel and none of the data was lost.

 

Hope this helps,

Nick

Labels