Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 728

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 729
Query Manager Multi-Ethnicity Expression - Local Variable as Counter | CompShack.com

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Query Manager Multi-Ethnicity Expression - Local Variable as Counter

1 reply [Last post]
Guest's picture
Guest

Hello. I have just started using Case When Expressions in Query Manager, and I am trying to write an expression to assign a single "Final Ethnicity" to each student. Student ethnicity data is stored in a table with 1 row for each ethnicity. A student who reported 1 ethnicity will have one row of data. A student who reported asian, pacific, and white will have 3 rows of data. Final Ethnicity definition rules: 1) any student who reported Hispanic, is Hispanic, 2) any student who only reported one ethnicity is that ethnicity, 3) any non-hispanic student who reported several ethnicity's is "Multi-Race". When Final Ethnicity rules were written in a different reporting tool, a Multi-Ethnicity counter variable was used. Does PSoft Query Manager even allow for initialization of a variable within an Expression or is this task beyond the capabilities of Query Manager expressions?

Any guidance will be appreciated. Thank you.

Guest's picture
Guest
Re: Query Manager Multi-Ethnicity Expression - Local ...

Any luck with this? I have the same question