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
Your data looks to be predictably separated by commas. The easiest solution is going to be using the "Text to Columns" tool (in the light green "Parse" tab of tools).
You can tell the tool which field to split and what character/symbol to use to separate the columns. If you know how many columns, just enter the correct number to split. Otherwise, may be a little trial and error to find the right number, but that should get you going.
From there you can rename them in the "Select" tool - or get a little more fancy using "Dynamic Rename" or some other tool depending on how much you want to manually type.
Tal como te menciona @severhart, deberás usar la herramienta de separador de columnas.
En la imagen está una configuración de esa herramienta la cual permite separar los datos de tu csv y con esos separados podrás seguir trabajandolos en Alteryx para que obtengas el formato que tu necesitas.