Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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