Data Extraction

So, I have attached a sample file from which I have to extract the usages that are highlighted in yellow.. all the level zeros which are preceded by 1 or whatever number. in excel I used to insert an extra column between my data. and I would use the following formula: =ifa2>a3, true, false. and then I would just filter in on all the true values. I have not had any luck in alteryx so far. Thank you.

After extracting all the parts (0s along with its level 1), the next step would be to find the duplicates within level 0. Marked green in my data table.

Sample Data.xlsx

Workflow

Output

Data Investigation

Accepted answers

ThizViz

I don't fully understand either, but the Alteryx equivalent for your Excel formula is to use the Multi-Row formula tool.

Excel works with row numbers, whereas the Multi-Row formula works with current row and current row plus or minus a specified number of rows.

In your example, row 3 is the current row so row 2 would be Row-1

Set it to create a new field and reword your formula this way [I'm assuming Column A is "level":

if [Row-1:level]>[level] then "True" else "False" endif

All comments

nerces

Could you please post a clearer explanation of what you would like? An example output with any relevant formulas you used to use would be beneficial.

jakaur32

The expected outcome in step one is highlighted in yellow.

ThizViz

I don't fully understand either, but the Alteryx equivalent for your Excel formula is to use the Multi-Row formula tool.

Excel works with row numbers, whereas the Multi-Row formula works with current row and current row plus or minus a specified number of rows.

In your example, row 3 is the current row so row 2 would be Row-1

Set it to create a new field and reword your formula this way [I'm assuming Column A is "level":

if [Row-1:level]>[level] then "True" else "False" endif

jakaur32

Thank you so much, that worked out great

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703