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
+45- Evangelist
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
+17- 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.
+45- Evangelist
Thanks @itay and @david_r by suggestions of transformers.
I have a register that is not works perfect:
Attached my template.
Thanks in Advance,
+17- 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
+45- Evangelist
itay wrote:
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
danilo_fme wrote:
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 ;)
+45- Evangelist
takashi wrote:
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.
+17- Supporter
takashi wrote:
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 ;)
+45- Evangelist
danilo_fme wrote:
@takashi perfect this transformer InlineQuerier. thanks :) The results was so amazing too.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.