About Elimination of Column(Mismatched)

hi there,

I need to eliminate the below column which i Marked in attached screen shot. i'm attaching the work book as well.What ever the Name occurred or appeared in Occurrence Column the same name should be populated on restoration as well. i have tried but it was unsuccessful.Can some one help me.

Thanks in advance.

Capture1.PNG

3 件の回答

Tableau Community Forums Member (Inactive) (Salesforce)
2019年9月6日 17:22
Suresh,

You can try
TRIM( LEFT( [Occurance], LEN( [Occurance] )-9 ) ) = TRIM( LEFT( [Restoration], LEN( [Restoration] )-11 ) )
and keep the True values.

Michel