Spotfire Ideas Portal
When inserting columns in Spotfire Cloud (desktop version) the data tables can only be joined on exact matches (=). It would be useful to be able to add in conditions such as > or <= to narrow down the number of matches to the desired row in the new data table e.g. I only want to insert data if the date within my first table is >= a date within my second table.
YES! I was just going to add this, happy to see it's already in the queue. I think this would be extremely useful for data wrangling.
A couple common use cases in the energy industry I have are as follows:
1) datetime start/stop range I'd like to merge to timeseries data
2) assigning well stage value to depth data (logs, directional surveys, etc.) based on stage top/bottom.
As an aside, this is needed on ALL platforms, not just Cloud. :)
This would fix a significant gap, which is that it is extremely difficult to try to match a pinpoint date field to data in another table that represents a date range.
Example: Joining a product quality result to a table that has specification limits that are valid between a specific start and end date. Goal is to pull in the correct specification limits for when the material was produced.