Multiline capture problem with first column
Altair EmployeeI'm using Monarch Pro 10.3 and am having trouble getting the first column to pull as one line of data, if it's a multi. I have a fixed width report with four columns of information. I have tried many options, but have the last 2 columns as detail and the first column as an append. I can get the model so capture the first column as multiline but it splits it into two columns. I need a line that matches the question with all answers. Currently I have ended the first column with Blank Field Values (1) and have tried End of Left Justification. I end up with the first line correctly and all the remaining answers with the second line as the question. I feel like I'm just missing the obvious. There are occasions where columns 2 and 3 might be blank.
I would like to see line 3 show as
If Snowwhite asked the dwarfs their felling, what would it be? Dwarf Grumpy Harrumpf.
Currently I see
what would it be? (blank space) Grumpy Harrumpf
fixed width report. first two lines are not part of the data but show the field length, type and name.
Every question ends with a ? Below are the four scenarios that will occur.
60 characters | 10 char | 10 char | 40 char |
Question | Level | Entity | Answer |
If Snowwhite asked the dwarfs their feeling, what would it be? | Dwarf | Sleepy | Tired |
|
| Dopey | Confused |
|
| Grumpy | Harrumpf |
|
| Happy | Joyful |
|
|
|
|
Do the dwarfs want Snowwhite to stay? |
| Group | Yes |
|
|
|
|
Will the queen give up looking? | Palace |
| No |
|
|
|
|
Who is the head dwarf? | Dwarfs | Dwarf | Doc |
|
|
|
|
Answers
-
Hello Karen,
I think you can do this in a single Detail trap, using the "Copy value from previous record" option for the Question and Level fields. I've sent you a model by email.
Best wishes,
Olly
0