Seperating the values inside the row

Hi Team,

In the below picture I just need "1 - Build Rapport (BEST) (online) " don't want data part.

There are 33000 rows in the same format with different names and lengths

Can we separate them in two different columns or can we apply the formula just to select the underlined part omitting the date field in Alteryx?

Data Investigation

Accepted answers

bpatel

@Kavya432 Almost there! try this!

Seperating values final.yxmd

All comments

Thableaus

Hi @Kavya432

An option - looking at your example - would be to use Text To Columns tool.

Use the "-" separator, and split the field to 3 columns.

Cheers,

bpatel

Hi @Kavya432 ,

i'm sure there is a better way to do this. But this is what i came up with. You can use the text to columns tools and have "-" as your delimiter and concatenate the two fields together.

Hope this helps!

Seperating values.yxmd

Kavya432

Thank you!

But there are some fields like this

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online) - 6/19/2019 11:00am EDT

In the above case its just selecting VOTH, is there any way we can just separate data part

The main reason behind this is I am joining Fugent table with MC_Desc table. can we use ike operator if part of that matches join or else don't .

Fugent Table has format like below

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online) - 6/19/2019 11:00am EDT

MC_Desc table has format like

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online)

Appreciate your help

Unmatched MC records.yxmd

bpatel

@Kavya432 i see.

i modified the workflow and used the regex tool instead. is this better?

Seperating values.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167