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

[gidon500]

hi

thanks , it works

gidon

[its_anandrjs]

Check below  script david in this you have to maintain only excel by use this you can exclude 100 to 1000 of pn field keys.

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);

Drop table ExcludeTable;

[anbu1984]

Can you mark helpful\correct answer

[gidon500]

hi

Thanks tried it it works perfect ,

since you are here  , can you tell me

how to remove a field  from a table

in order to reduce tha size of the module

thanks

gidon

[anbu1984]

Remove the field which you dont need from load statement

[its_anandrjs]

After the load statement like

Load Name,Address,Salary,LastName

From Location;

DROP Field LastName; //if you want to remove the LastName from table

//Or

DROP Fields LastName,Name; //if you want to remove the LastName,Namefrom table

[gidon500 · Accepted solution]

yes , please

how do i do it ?

[gidon500]

thank you very  much .

[its_anandrjs]

If you got correct answer from the thread so mark the thread as appropriate answer correct / helpful for references or for another question post new thread.

Regards

[anbu1984]

LOAD pn,

     qty

FROM

[Reduce items.xlsx]

(ooxml, embedded labels);

If you dont want column qty remove it from your load statement

LOAD pn

FROM

[Reduce items.xlsx]

(ooxml, embedded labels);

If you want to remove after loading, then use Drop

Drop field qty;