Combining multiple rows

danielact — Mon, 16 Jan 2012 20:20:57 GMT

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?

Re: Combining multiple rows

Mon, 16 Jan 2012 20:40:58 GMT

Use generic load.

I found out a way to do it in different post

topic Combining multiple rows in QlikView

Combining multiple rows

Re: Combining multiple rows