NeedHelp

[Pinky]

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

[ivoller]

See attached.

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

[LordNeilLord]

Hey @Pinky

Summarize tool for the win

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[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?

[LordNeilLord · Accepted solution]

Hey @Pinky

Try:

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

Neil

[ivoller · Accepted solution]

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