how to create a list box with expression

jim_chan — Sat, 26 Nov 2016 14:50:26 GMT

Hi guys,

i have created a list box. it is a code list box for example: 1256, 3478.

So, now i want to add in the name of this code. for example: 12 - apple, 34- green, 56 - banana, 78 - yellow.

Now, in my list box , i have only managed to get result - 1256 green 3478 yellow.

But my expected result has to be

1256 apple,green

3478 banana, yellow

i have attached my sample qvw file with inline data here.

Pls help !!

Re: how to create a list box with expression

maxgro — Sat, 26 Nov 2016 16:01:18 GMT

try the attachment

Listbox expression

aggr(concat(code_no, '', order) & ' ' & Concat(name, ',', order), big_code)

Script

dim_code:

LOAD * INLINE [

code_no, name

12, apple

34, banana

56, green

78, yellow

];

fact_table:

LOAD * INLINE [

big_code

1256

3478

];

link:

load big_code, left(big_code, 2) as code_no, 1 as order Resident fact_table;

load big_code, Right(big_code, 2) as code_no, 2 as order Resident fact_table;