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,
Page 1 / 1
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.
Thanks @itay and @david_r by suggestions of transformers.
I have a register that is not works perfect:
Attached my template.
Thanks in Advance,
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
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
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.
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.