Use Where clause in calculated column

[Former Member]

Dear Experts,

I have following logic to derive Customer and Vendors details in HANA studio using calculated column.

There is two column in the tables (Col1, Col2) based on the col2 values col1 value should be the customer or vendors.

if column col1='D' then col2 is the customer and if col1='K' then col2 is the vendors.

so I need to create calculated column like Col2 where col1='D' so how i will acheive this.

please help

thanks,

Regards,

Karuppiah N

[former_member210482 · Accepted solution]

Hi Karuppaih,

You can use if() condition for your requirement.

if(col1='d',customer,if(col1='k',vendor,and so on))

If conditions are more you can use case() function too. hope this helps

Regards,

Safiyu

[Former Member · Accepted solution]

Hi Safiyu,

Thanks for ur help, yes now I have got it.

Regards,

Karuppiah N

[former_member210482 · Accepted solution]

Hi Karuppaih,

Your Welcome

Cheers,

Safiyu