Hello all,
I have a Excel file with dates and i would like to read this XLS and take the Min and Max values dates.
I didnt find a transformer that make this.
Thanks in Advance,
Solved
Working with Dates - Statistics in and Max
+52- Celebrity
Best answer by itay
Hi @danilo_inovacao I think it has to do with the fact that you are grouping via the statisticscalculator, and possibly missing out on the " symbol in the date formatter had something to do with it too, but not sure...have a look at my take of it (with a little help from @takashi 's transformer)3
Hope this helps
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+18- Supporter
Hi @danilo_inovacao, you can use the attribute manager to copy the date into a new attribute, format it using de s setting and sorting + sampling twice once for the min and secondly for the max.
Hope this helps
To add to Itay's answer, use a DateFormatter to format the dates as YYYYMMDD and either use the Sorter/Sampler pattern or use the StatisticsCalculator to get the min/max values.
+52- Celebrity
Thanks @itay and @david_r by suggestions of transformers.
I have a register that is not works perfect:
Attached my template.
Thanks in Advance,
+18- Supporter
- Best Answer
Hi @danilo_inovacao I think it has to do with the fact that you are grouping via the statisticscalculator, and possibly missing out on the " symbol in the date formatter had something to do with it too, but not sure...have a look at my take of it (with a little help from @takashi 's transformer)3
Hope this helps
+52- Celebrity
Hi @danilo_inovacao I think it has to do with the fact that you are grouping via the statisticscalculator, and possibly missing out on the " symbol in the date formatter had something to do with it too, but not sure...have a look at my take of it (with a little help from @takashi 's transformer)3
Hope this helps
Thanks...Its Works :)
@itay and @takashi Very thanksssss
Thanks...Its Works :)
@itay and @takashi Very thanksssss
Unfortunately I was not able to run the workspace (V02) you posted. If you posted a workspace that reproduces exactly the same result as the screenshot, we could investigate the reason.
In addition, the InlineQuerier might also be useful in this case: -workspace-datas-v04.fmwt
There is more than one way ;)
+52- Celebrity
Hi @danilo_inovacao, good to hear. However, the reason why the min and max were reversed is still a mystery. Double quotations within a date format specifier are optional, and I don't think the missing double quotations may cause such a strange result.
Unfortunately I was not able to run the workspace (V02) you posted. If you posted a workspace that reproduces exactly the same result as the screenshot, we could investigate the reason.
In addition, the InlineQuerier might also be useful in this case: -workspace-datas-v04.fmwt
There is more than one way ;)
@takashi perfect this transformer InlineQuerier. thanks :) The results was so amazing too.
+18- Supporter
Hi @danilo_inovacao, good to hear. However, the reason why the min and max were reversed is still a mystery. Double quotations within a date format specifier are optional, and I don't think the missing double quotations may cause such a strange result.
Unfortunately I was not able to run the workspace (V02) you posted. If you posted a workspace that reproduces exactly the same result as the screenshot, we could investigate the reason.
In addition, the InlineQuerier might also be useful in this case: -workspace-datas-v04.fmwt
There is more than one way ;)
+52- Celebrity
@takashi perfect this transformer InlineQuerier. thanks :) The results was so amazing too.