Load data for Previous 8 quarters

[alec1982]

Hi guys,

What would be the best logic to use to load data for last 8 quarters outside of the current quarter.. If we are currently on 20134. then we need to load data starting from 20114

The quarter field looks like below..

Quarter

20111

20112

20113

20114

20121

20122

20123

20124

20131

20132

20133

20134

[alec1982]

Trying to find a way around it since Quarter is not working..

Thxs,

Alec

[alec1982 · Accepted solution]

I fixed this issue by creating an ID and load data where ID>Previous ID-8

[#4]

Hi Alec i have same requirement can you attach sample file please