Join Rowns

[#1]

Hi,

I have a question about joining rows and the scenaio is this:

I´ve got the table below:

ID | DESCRIPTION

1  | AAAAA

2  | BBBBB

3  | CCCCC

4  | DDDDD

5  | EEEEE

6  | FFFFFF

6  | GGGGG

7  | HHHHH

I am trying to have the rows from ID 3 to 7 showing as one row= 8 | ZZZZZZ, so when I click on 8 or ZZZZZ I have the equivalent to rows from 3 to 7.

Can someone assist me on this.

Kind regards,

Jorge

[jonathandienst · Accepted solution]

Hi

You could do something like this (assuming that you want to keep all the rows in the model and can select 3-7:

LOAD ID, 
          DESCRIPTION, 
          If(ID >= 3 And ID <= 7, 8, ID) As ID1,
          If(ID >= 3 And ID <= 7, 'ZZZZZ', DESCRIPTION) As DESCRIPTION1
Inline
[
ID , DESCRIPTION
1  , AAAAA
2  , BBBBB
3  , CCCCC
4  , DDDDD
5  , EEEEE
6  , FFFFFF
6  , GGGGG
7  , HHHHH
];

Now you can create a list box for field ID1. Clicking 8 here will select ID 3-7. You may want to also have a list box for ID. Rename ID1 and DESCRIPTION1 in a way that makes sense in your application.

Hope that helps

Jonathan

[#3]

Thanks a lot for your time and help, Jonathan, this is it!

Best regards,

Jorge