Ifelse in quicksight

Q&A
, ,
1

I have one field student id, based on student id i want to find out house of the student to which they belong to.

ifelse (student.std_id=‘123’,“tagore”,

‘Null’) AS housename,

I am writing this statement in select clause in the custom SQL but getting mismatched input error, predicate error.

2

Hello @bhumika18s
Can you share a screenshot of the step which you have tried so that I can test the same on my end?

3

I have got the solution, thanks for the response