Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

CSV text to column

SH_94
11 - Bolide

Dear community,

 

I would like to ask how we can prevent error when import the csv data which has the format below and how we can split them efficiently.

SH_94_1-1644740964240.png

 

Data in alteryx

SH_94_0-1644739971240.png

 

Example Row data copied from csv.

5000";"5001522358";"2021";"004";"S";"S";"4009

5000";"5001522358";"2021";"005";"S";"S";"4009

 

Appreciate if someone can advise me on how to deal with the data.

 

Thank you.

1 REPLY 1
Labels
Top Solution Authors