Databases
StackOverflow2013
Postsdbo
POjavascript coding - multiple inputs and outputs, and looking up outputs
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjavascript coding - multiple inputs and outputs, and looking up outputs
    primarykey
    data
    text
    <p>I am trying to code the following:</p> <p>there will be six inputs, say 1,2,3,4,5,6</p> <p>inputs 2-6 have two possible options (say yes and no)</p> <p>input 1 has seven possible options (say a-g)</p> <p>depending on which inputs are selected, a specific output will be generated.</p> <p>So if you had - a, yes, yes, no, no, no - it would generate outcome 'x'</p> <p>I have managed to create a list with all the possible input combinations (using python):</p> <pre><code>list = [[23,24,25,26,27,28,29],["male","female"],["true","false"],["true","false"],["true","false"],["true","false"]] r=[[]] for e in list: table = [] for item in e: for i in r: table.append(i+[item]) r = table print r </code></pre> <p>My next stage is to allocate an outcome to each of these options. I guess the best way to do this is just append the output to each list item so that</p> <p>for e in index, if e[0]-e[5] matches the input then print out e[6]</p> <p>Is this an ok way to do it? </p> <p><b>EDIT</b></p> <p>Just to make it clearer I just thought I'd explain what I am actually trying to do. It's a free tool for doctors (I'm a doc - it's not for commercial purposes just to improve patient care).</p> <p>It is a way of calculating risk for the patient, so there will be five questions the doc will input - e.g. male/female etc and depending on their inputs it will produce the outcome as a % risk for the patient. We are using years of previous patient outcome data to produce the table of outcome.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStessad
    1. UStessad
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjavascript coding - multiple inputs and outputs, and looking up outputs
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POjavascript coding - multiple inputs and outputs, and looking up outputs
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo 7*2*2*2*2*2 is 224 possible outcomes. You're saying you want to hard code all of those into a giant map of some sort?
      singulars
      1. POjavascript coding - multiple inputs and outputs, and looking up outputs
      1. USMike Christensen
    2. COAny more context available? Got any code you've tried already (regardless of language)?
      singulars
      1. POjavascript coding - multiple inputs and outputs, and looking up outputs
      1. USDaniel Attfield
    3. COMike - yes, that's right. A giant map that I can then look up to match the input.
      singulars
      1. POjavascript coding - multiple inputs and outputs, and looking up outputs
      1. UStessad
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload