Alteryx Designer Desktop

Get started with Alteryx Designer Desktop.

Delimiters CSV File

Danilo9017
8 - Asteroid

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 

 

 

2 REPLIES 2
severhart
8 - Asteroid

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.

mikjael
5 - Atom

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.