Csv problems with input data tool

[Danilo9017]

Hi All

I am trying to import a csv file on Alteryx.

But i have problems , it seems that all data are regrouped in one single row (file "screen1")

I attached you my input (file input csv ) and an example of the output desired as an exampe (file " output desired "). 

Do you know a way to solve the problem? 

Thank you 

Danilo 

[caltang]

Your first row - headers is already split into the associated columns. The count of headers is at 67, but when I split your data, I had to use 80 columns for some reason.

I'm guessing the quotations are affecting it. You can choose your selections under the Input tool.

Can you confirm how many headers are there supposed to be? And are quotations part of the same field?

[Danilo9017]

Thank you @caltang for your precious help 

The headers should be around 67. I attached you an example from the cleaned file that they send me

No quotation should not be in the same field. 

Thank you 

Danilo 

[caltang]

I'll be honest, your data is really messed up haha.

I see some rows are connected, meaning that one row may not contain all the information. What is the nature of this data? Where does it come from?

Do you have any other input format, perhaps .txt?

[Danilo9017]

Hi @caltang . The source should be D365. 

I think there should be something wrong with the extraction ahaha (for other stuff it was quite good) . I made several attempts also on my side but i got problems. 

I will try to ask clarification to the person who send me the extraction. 

I will keep you updated you, thank you!!