Resident Load Issue

[Anonymous]

    Hello Team,

Please help me with the below Resident Load.

Inventory:

LOAD [Inventory ID],

     Name,

     Description,

     [Unit Price],

     [Quantity in Stock],

     [Inventory Value],

     [Reorder Level],

     [Reorder Time in Days],

     [Quantity in Reorder],

     Discontinued?

FROM

[..\..\Inventory List.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Total Quantity]:

LOAD Inventory,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

[michael123]

[Total Quantity]:

LOAD Name,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

[prma7799]

from where inventory field come from ??

Try like this...

Total Quantity]:

LOAD Name,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

[avinashelite]

The below portion has the issue

[Total Quantity]:

LOAD Inventory,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

Group by should be always on the columns which acts a key ...and it should be part of the loading table in you case its different

[Anonymous]

Thanks for making understand

[Anonymous]

Thanks verymuch

[avinashelite]

Don't forget to mark the helpful and correct answers