Forum Discussion
Helper IIIGroup by - Aggregation (avoid N/A values and pick date)
First of all thanks to Mariuz for this time on helping me.
After spending a bit of time on checking everything that associated with these fields.
Here are the finding and I made the below necessary changes to achieve the desired result.
- The datatype of 'Date' field was 'Text' --> hence the behaviour of displaying N/A instead of Date, I reckon. Changed it to 'Date' then the aggregation was working fine.
- To handle 'N/A' values --> I have replaced it with a dummy date '1/1/1970' and applied aggregation to pick Max date and once all the steps are done, replaced with N/A instead of dummy date.
Regards,
David
Helper IIIHi Mariusz
This step seems to be replacing the 'null' values with 'N/A' for Date field.
The need is to pick the date field if there are duplicates (where one is date other is N/A)
Also, there are other entries (without duplicates) where the values can be N/A.
So I want to eliminate/Filter 'N/A', only when we have duplicates for the ID.
Is there a way, to filter out in this way?
Helper IIIFirst of all thanks to Mariuz for this time on helping me.
After spending a bit of time on checking everything that associated with these fields.
Here are the finding and I made the below necessary changes to achieve the desired result.
- The datatype of 'Date' field was 'Text' --> hence the behaviour of displaying N/A instead of Date, I reckon. Changed it to 'Date' then the aggregation was working fine.
- To handle 'N/A' values --> I have replaced it with a dummy date '1/1/1970' and applied aggregation to pick Max date and once all the steps are done, replaced with N/A instead of dummy date.
Regards,
David