on 01-23-2015 9:33 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.