Hi,
I have a requirement to group and sum the data based on fields and dispaly it in a table format in VBCS.
I have a requirement to fetch the data from an external rest API to retrieve Onhand balances and display it in a table on search of a button.
Table should contain fields OrgCode, itemNumber, SubinventoryCode, Locator and PrimaryQty.
I have done the above task.
I am getting the attached data:
I got stuck
Next steps-> I need to group all the fields and sum the primaryQuantity.
In the attached image their are two records with same organizationCode, itemnumber, subinventoryCode
I need only one record with sum of primaryquantity i.e; 2+3=5.