Split Data Feeding Into Alteryx in One Row

Question

Hello,

I have data in CSV files. The data comes in with all information in 1 column. I am looking to have 2 columns: 1 with the username and another with active/inactive. Some columns have extra text such as "(password)". I would like to avoid manually manipulating the Excel file as I have many files in this exact same format and will receive files in this format frequently.

How the data currently looks in Excel

How the data currently looks in Alteryx

How I would like the data to look in Alteryx

Emil_Kos · Answer

Hi @user_7346,

Not sure if you want to keep a password or not but maybe you can try text to columns tool

Output:

Text to columns.yxmd

user_7346 · Answer

Hello,

The raw data is attached. Thank you for your help!

Raw Data.xlsx

echuong1 · Answer

You could use regex to clean this up.

Another method would be to use a text to columns with a delimiter on "(" to remove the password entries. From there, you can use a simple regex to separate out the data before and after the capital letter.

Are you able to upload a copy of your input file?