Solved

[microwin88x]

Solved

[Gysbert_Wassenaar]

LOAD

     PERIOD,

     VALUE

FROM

     SOMEWHERE

WHERE

     NOT WildMatch(PERIOD,'2015*') OR PERIOD = '201512'

;

[microwin88x]

Thanks, Gysbert! The thing is that I would need to do the same process for the next years (2016, 2017, etc)

[Gysbert_Wassenaar]

Then use

WHERE

     WildMatch(PERIOD,'*12')

[microwin88x]

Perfect! I'll give it a try. Thanks!

[Mark_Little · Accepted solution]

Hi,

I am guessing I miss understood what you were wanting as the above will only load the where the period ends in 12.

Just as I was was working on this before the correct answer popped up, I thought I would post this anyhow

This would give you the table shown above, i.e. period 12 for complete years and then monthly period for the current or incomplete years.

Mark