Icon

Dynamic Period Selection_​V2

Calculate MAX Period, and use it as a filter Sort DESC by PERIOD, take the first 2 ROWSThe sorting ensures that the first two rows are the last added Period Node 92Node 93Max PeriodTO variableFilter the PeriodDescc by PeriodTake 2 rowsfrom TopNode 99 Table Creator Pivoting GroupBy Table Rowto Variable Row Filter Sorter Row Sampling Pivoting Calculate MAX Period, and use it as a filter Sort DESC by PERIOD, take the first 2 ROWSThe sorting ensures that the first two rows are the last added Period Node 92Node 93Max PeriodTO variableFilter the PeriodDescc by PeriodTake 2 rowsfrom TopNode 99 Table Creator Pivoting GroupBy Table Rowto Variable Row Filter Sorter Row Sampling Pivoting

Nodes

Extensions

Links