Aditya Koyyaamudi

1. Community
2. Questions & Answers
3. lpad & substr

Thanks Joel, i'll definitely do that.

• View comment
• Aditya Koyyaamudi
• July 13, 2018 13:54
• 0 votes

1. Community
2. Questions & Answers
3. lpad & substr

Thanks Sabeel, that works.

• View comment
• Aditya Koyyaamudi
• July 13, 2018 13:52
• 0 votes

1. Community
2. Questions & Answers
3. translate

Thank you Sabeel! that works.

• View comment
• Aditya Koyyaamudi
• July 02, 2018 19:08
• 0 votes

1. Community
2. Questions & Answers
3. Editing the Workbook

Thanks for the support Joel

• View comment
• Aditya Koyyaamudi
• June 20, 2018 15:36
• 0 votes

1. Community
2. Questions & Answers
3. Datatype

Thanks Joel, but how can I give column name as default value? the column is LOAN_AMOUNT and it has different values if it does not match any cases then it should display actual value present  in th...

• View comment
• Aditya Koyyaamudi
• June 20, 2018 15:32
• 0 votes

1. Community
2. Questions & Answers
3. Datatype

Hi Alan, Could you please help me on how to write below case statement. case when LOAN_AMOUNT is null then null when trim(LOAN_AMOUNT) = ' ' then null when upper(LOAN_AMOUNT) like '%N%A%' then 9999...

• View comment
• Aditya Koyyaamudi
• June 20, 2018 15:12
• 0 votes

1. Community
2. Questions & Answers
3. Datatype

CASE statement is working fine, thanks for the support Alan!  

• View comment
• Aditya Koyyaamudi
• June 19, 2018 15:58
• 0 votes

1. Community
2. Questions & Answers
3. Datatype

Hi Alan, Thanks for  yours response. I have a column with values 'APPROVED',  'NOT APPROVED,  'PENDING' and the data type is STRING , now i want to create new column with condition 'if APPROVED the...

• View comment
• Aditya Koyyaamudi
• June 19, 2018 15:35
• 0 votes

1. Community
2. Questions & Answers
3. Datatype

I'm trying to write an IF condition and I'm getting above error. Can someone help me to change the datatype of the column

• View comment
• Aditya Koyyaamudi
• June 19, 2018 14:22
• 0 votes