Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
karan_kn
Creator II
Creator II

Create Flag If contains specific Value

Create Flag for ID, If Value contains 'AA' then 'High' else 'Low'

karan_kn_0-1656946333113.png

 

 

Labels (3)
3 Replies
Bunim
Contributor III
Contributor III

if(value='AA','High','Low')

karan_kn
Creator II
Creator II
Author

not by value, the flag should be based on ID

Ex: 500001 is High, 500002 is low

MarcoWedel

Join (YourTable)
LOAD ID,
     If(Min(Value='AA'),'High','Low') as Flag
Resident YourTable
Group By ID;