Hello, hope you can help me with a transform issue. I have this sales index that as an id, timestamp and value fields and Im working on another index (sales-latest) that dynamically searches for unique ids and the most recent timestamps of that id (all this from the sales index). I'm anexing the scripts below:
When I execute the _start query it works the first time but everytime I insert a new id or an entry with a more recent timestamp for a specific id it does not update.
Could you help me?
What you are describing sounds like a latest transform, not a pivot transform
If you want a resulting index that shows the last time a transaction was made by id, that is a latest transform ... it will keep the whole entry so you will also have the values of that latest entry.
So in your case that would look something like this... I would use the UI the first time.
Hi, thank you for the response. That is not quite what I'm looking for, I want the transform to dynamically update the new index everytime a new entry is saved in the source index, I tried thta script and it did not worked. It is probably my Basic License
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.