This content has been marked as final. Show 3 replies
I have an existing column Portfolio with values 'APPS', 'BPO', and 'ITO'. I want to create a new column GBU with values 'ABS' and 'ITO' where 'ABS' is 'APPS' and 'BPO' from the first column.
I have tried:
if(Portfolio='ITO','ITO') and if(Portfolio='APPS','ABS') and if(Portfolio='BPO','ABS') as GBU
but it's not working for me