topic Re: load add lines in QlikView

load add lines

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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)

;

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

how can be done this?

many thanks for help

rgs

sunny_talwar — Wed, 25 May 2016 16:30:59 GMT

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 — Wed, 25 May 2016 21:15:28 GMT

Hey Sunny

it works, just need to change from

Concatenate (Dim_PimItem)

LOAD DISTINCT %Item,

%Item as %BulkItem

Resident Dim_PimItem;

Concatenate (Dim_PimItem)

LOAD DISTINCT %BulkItem,

%BulkItemas %Item

Resident Dim_PimItem;

Many thansk