Csv problems with input data tool

Question

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

screen 1.JPG

desidered output excel.xlsx

Input csv.csv

Danilo9017 · Answer

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!!

caltang · Answer

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 · Answer

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

headerfile.xlsx