This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's an approach you could use with the multirow formula tool, essentially I used the tool to identify instances where the value had a period, or the row below had a period and flagged them. Then from there I just filtered on the flag.
Ignore the first sample tool, I had to put some text in the text input tool because the numbers kept defaulting to numeric data types and losing the decimal.
You can use a Formula tool to add a column that'll check if you should get the data or not. First, create the column with a "YES" or any other word if the data contains a period. Then, using a multi-row formula, check if the next row has a period, if it does, also set it as a "YES". Finally, just filter the data.
It's Alteryx & there is a thousand ways to do any one thing, so I'm sure there is a statement you could use to accomplish this, I'm just not sure what it is haha. If you are waiting for feedback to accomplish something though, the way I would attack this is below:
I would use the Record ID tool on your input data, then a filter to grab any of the records that contain the decimal, then use a Formula tool on those records, creating a new ID field where you take the records record id & subtract 1. You can then use this new ID to match to the other records that fell out of the first filter. I added a sort to give you your original order back & then used the Select to drop the Record ID field. Hope this helps!