Inputting CSV files with wrapped text

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.

Coffee test.xlsx

Screenshot 2024-03-11 144300.png

Input

Accepted answers

binu_acs

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

csv_11032024.yxzp

All comments

Manoj_k

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

Screenshot 2024-03-11 143205.png

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.

Coffee test.csv

binu_acs

@nikhilnijhar I dont see any issue with the csv file

nikhilnijhar

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

Screenshot 2024-03-11 174518.png

binu_acs

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

csv_11032024.yxzp

nikhilnijhar

@binu_acs 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.

binu_acs

@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 @binu_acs

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

AMP Options.png

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

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335