Extract data from column

Metadata21

Hi All,

I am still new to Alteryx and I have a question to ask about extracting data from a column.

I basically need 3 columns as an output (invoice, vendor and intercompany ref)

I require the invoice number vendor and intercompany ref from the description field.

Please see attached for reference.

Alteryx.PNG

Designer Cloud

Custom Tools

Common Use Cases

Expression

Interface Tools

Data Investigation

Accepted answers

binu_acs

@Metadata21 Are you looking for something like this?

Text_To_Column_16_05.yxmd

DataNath

How's this? Skips the Intercompany Ref if it's not present - have added a table on to show this properly. The RegEx used assumes that all the values being pulled out will follow the same format. Let us know if that's not the case and we can amend. Edit: Wasn't account for the Intercompany Ref / NEXT / NEXT rows in my original, have amended.

Extract from description - optional capture group.yxmd

DataNath

@Metadata21 is this what you're after? Have attached the amended workflow.

Extract from description - optional capture group.yxmd

All comments

binu_acs

@Metadata21 Can you provide the input file and expected output file?

Metadata21

Please see attached - the columns I would like to create are K. L and M. Same as the input but in Alteryx

dummy data.xls

Metadata21

now attached

binu_acs

@Metadata21 Are you looking for something like this?

Text_To_Column_16_05.yxmd

DataNath

Extract from description - optional capture group.yxmd

Metadata21

@DataNath @binu_acs thank you both for your help! both of your solution works!

Metadata21

@DataNath could you help me with one more thing please :-) it would complete my workflow.. i require a formula that matches data from intercompany column that matches with the invoice and entity and spits it out in another column (column N and O in my screenshot) see attached for the formula as i am probably not making sense.

If you have a look at the screenshot the anything with acc 899999 matches with the intercompany ref tab. this does include the data that matches against its vendor and inv number.

Alteryx.PNG

Alteryx 2.PNG

DataNath

@Metadata21 is this what you're after? Have attached the amended workflow.

Extract from description - optional capture group.yxmd

Metadata21

@DataNath OMG you are an absolute legend!! thank you so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703