Subquerying using a Calculated Field

[bonfire09]

I am trying to create a subquery in Cognos that checks if the value of one column exists in another column in another query. I have one query with accounts and another query that shows if the account can be accessed online and I've join both queries. I want to create a calculated column that basically binary codes 1 for accounting having online connection and 0 not. I have tried

case when [acctno] in ([online_account]) then 1 else 0 end. But its showing a parsing error.  Any help would be great. Thanks!

[Pratap Reddy]

I am trying to create a subquery in Cognos that checks if the value of one column exists in another column in another query. I have one query with accounts and another query that shows if the account can be accessed online and I've join both queries. I want to create a calculated column that basically binary codes 1 for accounting having online connection and 0 not. I have tried

case when [acctno] in ([online_account]) then 1 else 0 end. But its showing a parsing error.  Any help would be great. Thanks!

case
when [Product line] = [Product line1]
then 1
else
0
end

Regards,
Pratap

[MFGF]

I am trying to create a subquery in Cognos that checks if the value of one column exists in another column in another query. I have one query with accounts and another query that shows if the account can be accessed online and I've join both queries. I want to create a calculated column that basically binary codes 1 for accounting having online connection and 0 not. I have tried

case when [acctno] in ([online_account]) then 1 else 0 end. But its showing a parsing error.  Any help would be great. Thanks!

Hi,

What is the error you are seeing?

MF.