Latest version filters

[ranibosch]

Good day,

please see my excel spreadsheet attached with fields and the required results.

I'm unsure on how to write the script to get the latest version of a BOM header.

[niclaz79]

Hi,

Temp:

LOAD

     [Production BOM Version.Description],

     [Production BOM Version.Version Code]

FROM

[FileName and Sheetname etc]

where

     [Production BOM Version.Status] = 1;

Temp2:

LOAD

     Max([Production BOM Version.Version Code]) as MaxVersion

Resident Temp;

let vMaxVersion = Peek('MaxVersion',0,'Temp2');

drop table Temp2;

ProductionBOM:

LOAD

          [Production BOM Version.Description]

Resident Temp

where [Production BOM Version.Version Code] = $(vMaxVersion);

drop table Temp;