The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
how to identify the period is complete or not
sgnarkhede2016
Member Posts: 152 Contributor II
in Help
Hello,
If the period will be start or end with the middle then exclude that period
i.e Data Available from 15May2020 up to 29Nov2022 then exclude May and Nov month data
lll'y For Quarter,Half-Year,Year how to do this.
Thanks,
Sachin N
lll'y For Quarter,Half-Year,Year how to do this.
Thanks,
Sachin N
0
Best Answer
-
BalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 UnicornHi!
You could try to extract the year-month part of the date and generate a simple table with year-month and the number of days therein. You should be able to do that easily in a spreadsheet application Then join on the month, use Aggregate to count the days and if the number of days is less than the number of days in that month, remove the data.
Regards,
Balázs0