Inputting CSV files with wrapped text

[nikhilnijhar]

Hello everyone,

I am unsure on how to input CSV files that contain wrapped text into Alteryx. 

The attached file showcases how my input looks like in the 1st sheet. When i input this into Alteryx, my data seems to take the blank spaces caused by the wrapped text as rows in Alteryx and is giving me more rows than the input file.

My desired output is shown in the 2nd sheet of the sample file attached and I would like to replicate it in Alteryx. 

Any help would be greatly appreciated. Thank you.

[Manoj_k]

Hi @nikhilnijhar  for me there is no change in the input data and the output data in alteryx.

 

[nikhilnijhar]

Thank you for letting me know @Manoj_k . It seems that the issue only occurs when important a .csv file and not with an .xlsx file. 

I have uploaded a new input file.

[binuacs]

@nikhilnijhar I dont see any issue with the csv file

[nikhilnijhar]

@binuacs How strange, I get this error. My input data configuration is identical to yours as well.

[binuacs · Accepted solution]

@nikhilnijhar try the attached workflow, and also try to run the workflow by turn off the AMP engine

[nikhilnijhar]

@binuacs The issue was indeed caused by the AMP engine being turned on. Thank you!

Any idea why having the AMP engine turned on caused this? I have also noticed issues with running downloaded external macros as well and it having errors with the function being on.

[binuacs]

@nikhilnijhar I am not sure why the AMP engine causing the errors, @danilang do you have any insight on the AMP issue mentioned above?

[danilang]

Hi @binuacs 

While I'm not privy to all the details of the new AMP engine, I do know that all lot of the functionality had to be rewritten to allow multithreading.  It looks like the Input Data tool is one those.  It does look like Alteryx did a fair amount of testing around inputs and found this issue.  There are two new AMP specific options

The first one deals with your issue, @nikhilnijhar.  Check it and the file will be read correctly.

For the macro issues, they may be addressed Alteryx Engine and AMP - Main differences  or possibly here Tool use with AMP

Dan