NeedHelp

Hi,

I need to remove or ignore the numbers where their each first and last condition is true for each number.If you see my below data 'BBB' and 'DDD' numbers first and last condition is true. Can anyone help on this?

Number	Condition
AAA	TRUE
AAA	TRUE
AAA	FALSE
BBB	TRUE
BBB	TRUE
CCC	TRUE
CCC	TRUE
CCC	FALSE
DDD	TRUE
DDD	TRUE

Common Use Cases

Accepted answers

LordNeilLord

Hey @Pinky

Try:

[First_Condition]= "TRUE" && [Last_Condition] ="TRUE"

Neil

ivoller

Maybe [First]=="TRUE" && [Last]=="TRUE"

All comments

ivoller

See attached.

Summarize to get first and last, filter and then join back to original data set.

ignore nums.yxmd

LordNeilLord

Hey @Pinky

Summarize tool for the win

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

FirstLast.yxmd

Pinky

Thanks for your response!

I almost got it. I still have small question here.

I am using this condition [First_Condition]==[Last_Condition].I want only both first and last condition is TRUE. There are some first and last condition is 'False'.Those numbers are converting into 'TRUE' if i use the formula [First_Condition]==[Last_Condition].

I need to ignore only [First_Condition]==[Last_Condition] ==''TRUE". Is there any way to implement this?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703