Creat one list out of two

[david_ze]

Hi all,

I have two lists which I'd like to combine them.

list of customers consist's of cust numbers:
1
2
3
4
5

and a list of items consist's of:
x
y
z

I'd like to attache to each item (x, y, z) all cust numbers and to create a new list as follows:
x1
x2
x3
x4
x5
y1
y2
y3
y4
y5
z1
z2
z3
z4
z5

I'll appreciate if you can advise me on the way to do this.

Thanks in advanced.
Best regards,
David

[lironbaram]

try this script

DataTemp:

LOAD * INLINE [
F1
X
Y
Z
];
join
LOAD * INLINE [
F2
1
2
3
4
5
];


Data:
load F1&F2 as FieldList
Resident DataTemp;

drop table DataTemp;

[Anonymous]

If the pupose is to get a list box, there is no need to scipt changes.  Just use calculated list box with expression

F1 & F2

[david_ze]

Thanks Liron.