Groups would have to shown in list box

[Anonymous]

Hi guys,

           i have empno in emp table and i have empno as groups like

      empno(6745,2398,2944,2323,2929,0129,0394) as empnogroup1 and

      empno(2382,4575,5854,3023,4232,4352) as empnogroup2   and

      empno(4244,3435,6979,7983,2121) as empnogroup3

these above groups should i have to place in listbox(empnogroup1,empnogroup2,empnogroup3)

Now My requirement is these fields should be declare in INLINE lode in script part and also these should be linked with empno in tabular view Please share the code for that??(don't change these in design expression part only place these groups in edit script part)

[MayilVahanan]

Hi

Try like this

TableA:

Load empNo, empNo AS empnogroup1, empNo as empnogroup2,empNo as empnogroup3 from TableA;

Load * Inline

[

empnogroup1

6745

];

Load * Inline

[

empnogroup2

2382

4575

5854

3023

];

Load * Inline

[

empnogroup3

4244

3435

6979

7983

2121

];

[Anonymous]

if we place empno as empgroup1 then it will take all empnos into empgroup1 .

please change any modification

[MayilVahanan]

Hi

Hope it helps

Load * Inline

[

empnogroup1

6745

];

Load * Inline

[

empnogroup2

2382

4575

5854

3023

];

Load * Inline

[

empnogroup3

4244

3435

6979

7983

2121

];

TableA:

Load empNo, if(Exists(empnogroup1,empNo), empNo) AS empnogroup1, If(Exists(empnogroup2, empNo),empNo) as empnogroup2,

If(Exists(empnogroup3, empNo),empNo) as empnogroup3;

LOAD * Inline

[

empNo

6745

2382

4575

5854

3023

3435

6979

];