load add lines

[Anonymous]

Hey guys

im sure you can help me pretty fast on this

I have a table which shows a referenc

Dim_PimItem:

LOAD     %Item,

        %BulkItem

From

$(dirQVD)_Generic\Dim_PimItemData.qvd

(qvd)

;

%BulkItem	%Item
5620758	4236968
5620758	4237583
5620758	4244000

Now i would like to add the %bulk to %Item as reference, the result should look like this

%BulkItem	%Item
5620758	4236968
5620758	4237583
5620758	4244000
5620758	5620758

how can be done this?

many thanks for help

rgs

[sunny_talwar · Accepted solution]

May be like this:

Dim_PimItem:

LOAD     %Item,

        %BulkItem

From

$(dirQVD)_Generic\Dim_PimItemData.qvd

(qvd);

Concatenate (Dim_PimItem)

LOAD DISTINCT %Item,

          %Item as %BulkItem

Resident Dim_PimItem;

[Anonymous]

Hey Sunny

it works, just need to change from

Concatenate (Dim_PimItem)

LOAD DISTINCT %Item,

          %Item as %BulkItem

Resident Dim_PimItem;

To

Concatenate (Dim_PimItem)

LOAD DISTINCT %BulkItem,

          %BulkItemas %Item

Resident Dim_PimItem;

Many thansk