When parsing address not all records are output

[lbolin]

I am trying to parse an address for unstructured data that was scraped from a website. I think I have it just about figured out. The issue I am having is that when I use my 2000 record data only 1988 records are out put. I need all data to output. I see when the record count goes from 2000 to 1988 when the records are joined after splitting then to rows. I got that solution from another discussion question and I do have enough understanding of it to work out the issue. 

[atcodedog05]

Hi @lbolin 

Can you please provide the data file.

We cannot run workflow without that.

[lbolin]

Here is the data

[atcodedog05]

Hi @lbolin 

Is very unstructured its really hard to parse it. Pretty much not possible by me.

Hi @PhilipMannering do want to give this one a Try🙂

[lbolin]

Thank you for looking at it. I am new to this so I am glad I am not the only one .😂

[atcodedog05]

@lbolin 

Honestly the data is very unstructured its going to be super hard to parse it out

So yeah😅

[lbolin]

This is my first project in Alteryx at a new job. I guess you can say I am learning my Fire. 🤓

[atcodedog05]

Thats great to hear 

All the best with your journey🙂 @lbolin