Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Extracting Names From Column

Asimkz157
7 - Meteor

Hello all, I have a column that contains names with a bunch of other string values.  Is there way to create a new column and just extract the names?  Attached sample.  Rows 2, 22 and 42 are the name fields I need. 

4 REPLIES 4
Kamran1991
11 - Bolide

Hi,

 

I hope this would answer your query.

 

Thanks!!

Extracting Names From Column.PNG

Kamran1991
11 - Bolide

You can use this workflow also, if you want names in ProperCase, as given in attached pic

Extracting Names From Column.PNG

jrgo
14 - Magnetar

Hi @Asimkz157 

 

I came up with a couple options to approach this which is depended on what can change on that input table. Option 1 assumes that there's an equal amount of rows in between the the row extracted last. In this case, after the 20th row. This option allows for any fluctuation on the order of what's in between, but will fail if that can't be relied on.

 

Option 2 uses REGEX within the Multi-Row formula tool that looks at the next row and looks for a specific string pattern. If found, it copies the TM Name value into the new field, otherwise it stays NULL. This option is good if you can't rely on the amount of values in between, but will fail if the next field value is not always the CY [Mmm YYYY] - [Mmm YYYY] value.

 

jrgo_0-1628802822487.png

 

If the consistency is never the same, there's nothing much else that can be used (from the sample you provided) to create a logical approach for flag a specific row.

 

Hope this helps!

Jimmy

Asimkz157
7 - Meteor

Thank you guys, both solutions worked.  Hopefully they hold up in the long run. 

Labels