I have the below data for which I need to check Flag for 1 if have received data for complete Quarter else 0. for eg. in the below mentioned table, I have received data till May which is Q2 and I'm still expecting data for 1 month in Q2 so my flag will be 1 for Q1 only and in July when i get Jun data complete Q2 will be flagged as 1. Please help
Status May
Flag | Month | Month_No | Qtr |
1 | Jan | 1 | Q1 |
1 | Feb | 2 | Q1 |
1 | Mar | 3 | Q1 |
0 | Apr | 4 | Q2 |
0 | May | 5 | Q2 |
0 | 6 | Q2 | |
0 | 7 | Q3 | |
0 | 8 | Q3 | |
0 | 9 | Q3 | |
0 | 10 | Q4 | |
0 | 11 | Q4 | |
0 | 12 | Q4 |
Status in Jun
Flag | Month | Month_No | Qtr |
1 | Jan | 1 | Q1 |
1 | Feb | 2 | Q1 |
1 | Mar | 3 | Q1 |
1 | Apr | 4 | Q2 |
1 | May | 5 | Q2 |
1 | Jun | 6 | Q2 |
0 | 7 | Q3 | |
0 | 8 | Q3 | |
0 | 9 | Q3 | |
0 | 10 | Q4 | |
0 | 11 | Q4 | |
0 | 12 | Q4 |
Solved! Go to Solution.
Hi @SamSurya
How do you know you have received data from a specific month? Is this based on current date? Like, by July 1st, will you have received data from June already?
Cheers,
yes, I have a field which has current feed date. so in my case its 05/31/2020 so have recievd data till may
wonderful!!!.. this works for me...
cheers,
Sam