Combining multiple rows

[danielact]

This question seems like it should be easy, for some reason I just can't think of the answer.

So I have a table that does not really have a unique key. Let's call the first column "Order" and the second column "Item_Num". There can be multiple rows for one order, each with a different Item_Num.

I want (in my script) to create an indicator based on what items are listed for one order.

If the orginal data was like this:

Order     Item

1               1

2               2

2               3

3               1

3               3

I want a new table (created in the script) to look like this:

Order     Item1     Item2     Item3

1          x                        

2                         x          x

3          x                         x    

Any ideas on how to do it?

[#2]

Use generic load.

I found out a way to do it in different post

JJ