I am trying to load some data from a given csv-file.
Very simlified extract of the data:
I have the following requirements:
* if I filter for claim 4711 amount should be 2 (not 4) * if I filter for claim 4711 the sum of cost should be 25 * if I filter for unit 10 sum of cost should be 25 * if I count the number of claims it should be 3 (not 4)
I already have the idea that in the LOAD I should use the keyword "distinct" - but I don´t know exactly how to do this.
Your requirements 1, 2 and 4 might be manageable with a distinct in the load or the UI expressions but not 3. I assume that you need some more logic to prepare all wanted results within a single table and/or to split the task into several tables.
Wow, thank you all for your very helpful answers. I think especially the answer of Lanlizgu will lead me to the right direction. I´ll need some more testing and will mark an answer as solution asap. But also I guess I´ll have some further questions 😉