reduce items

[gidon500]

Hi

I have inventory file , includes pn and qty

as well as list of pn to exclude fro the invery

what is the best way to do it

enclosed a file with data

sheet - data , with  original data .

sheet - exclude - pn to be removed fro the original data

sheet - after -  required data ( after the remove )

thanks

gidon

[nizamsha]

=sum({$<pn-={"105","106"}>}qty)

[nizamsha]

pn as dimension

expression  =sum({$<pn-={"105","106"}>}qty)

[its_anandrjs]

New Update

Write for load statement like below if you have few records otherwise use where exists

LOAD pn,

     qty

FROM

(ooxml, embedded labels, table is data)

Where not Match(pn,'105','107');

Or

In Front end for expression

=Sum({$<pn -= {'105','106'}>} qty )

[gidon500]

Hi Nizam

Thanks for the fast answer

I cannot use this script , as the list is much bigger .

and it change every day

thanks gidon

[#6]

hi david i think you can do anand has said ,i think it is correct

[anbu1984]

Data:

LOAD pn,

     qty

FROM

[Reduce items.xlsx]

(ooxml, embedded labels);

Left Join(Data)

Exclude:

LOAD pn, RowNo() As Rn

FROM

[Reduce items.xlsx]

(ooxml, embedded labels, table is exclude);

Final:

NoConcatenate

Load pn,qty,Rn Resident Data where IsNull(Rn);

Drop table Data;

[gidon500]

Hi

i cannot be specific with the pn , it changed

and the list is very long

thanks

any right or keep command  ?

gidon

[anbu1984]

Check my script below

[its_anandrjs]

You can write this way in the load script

ExcludeTable:

LOAD pn as ExcludeKey;

LOAD pn

FROM

(ooxml, embedded labels, table is exclude);

LOAD pn,

     qty

FROM

(ooxml, embedded labels, table is data) Where not Exists(ExcludeKey,pn);