Scrubbing support tickets for relevant information

[Candlelit]

I am working to automate our CRM data collection process through downloading our support inbox as a csv file and scrubbing it for data in alteryx.

The data needed is in the "body" of the email. What I have done so far is to split text to columns by line to create the "input" tab.

I am looking to transform it into a table like the "output" tab. The tricky aspect is that there can be multiple usernames & balances tagged to each email. Rather lost as I am very new to Alteryx and data analytics in general.

Any help would be appreciated!

[mceleavey]

Hi @Candlelit ,

Can you provide the raw data as you receive it? 

Thanks,

M.