Parse Formula for Different Variables Similar to Excel Flash Fill

Question

Hello,

Is there a function similar to Excel Flash Fill in Alteryx?

Please see a sample of input data and desired output.

Thank you.

Parse.xlsx

neilgallen · Accepted Answer

You just need the parse to columns tool, using the “_” as the separator. No function needed!