Pulling specific criteria in a cell and putting it into a column

[jessy_chow]

Below is an example of my data. I am hoping to get the  row with "**660000 Salaries: Inscope" into the column. See below for after results. The"**660000 Salaries: Inscope" cell can vary with different accounts, however it is always consistent with "**" in the cell. 

The "**" cell is a total cell for the cells listed above. How can I create a flowchart that can do this. Thanks everyone for their help! 

Before

AFTER

 

[abacon]

@jessy_chow Does filtering out the field you are looking for with a Contains([column name], "*") then using an append fields tool after the filter get you what you want?

Bacon

[jessy_chow]

Thanks for the suggestion, however it doesn't. It ends up adding all the cells with "*  " to all the cells and doesn't it each time with each account containing "**" so it like multiples my data. 

 Shown is how account * 600000 Salaries: Inscope is applied to the Source_F2 column, then * 600010 Salaries: Mgmt is applied to all the data in Source_F2 again. 

[abacon]

What if you change the filter to be exactly what you are looking for? * 600000 Salaries: Inscope

[jessy_chow]

The accounts may not be the same each time so I don't want to specify to specific accounts. 

[abacon]

How do you know it's the right field for that account? This isn't a ton to go off of to be helpful.

I would find a way to parse out the cell you are wanting then append it to the data. Options are Regex, plain text, lookup table with the desired cells to be found.

Sorry I can't be more helpful but again, not a ton to go off of.

Bacon

[jessy_chow]

Sorry - attached is the excel file. I am trying to have alteryx do exactly what the macro's are doing in the excel file. Hopefully that provides some clarity. 

[abacon · Accepted solution]

Ah that is very helpful, this workflow does what you are looking for. There are definitely other ways to do this too for the more advanced with Regex!

Bacon

[binuacs · Accepted solution]

@jessy_chow one way of doing this

[jessy_chow · Accepted solution]

 Thanks everyone for your help! Both methods worked!