Parsing PDFs - concatenate indefinite number of multiple rows containing strings

Question

Hi folks,

I'm parsing a PDF in Alteryx and trying to put the data into a more usable format.

An issue I've run up against is that there is a description coming in over a few lines, which I would like to concatenate into one line. The first row contains a value which also matches a value in the last row of the description. Is there a multi-row formula I can use for this? I've had a go at a couple but not having much luck!

Thanks in advance

danilang · Accepted Answer

Hi @Rachael_OS

If your input looks like this

You can use a multi-row tool to fill in the missing marker values and then use a Summarize tool to concatenate the values

If your input has the marker on all the rows, you can get rid of the Multi-row tool.  Either way, your output looks like this

Dan

Rachael_OS · Accepted Answer

Worked like a charm - thanks a mill!