# How to display combined values in the data viewer **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** help, data-viewer\ **Created:** [May 5, 2024, 10:33pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482 "2024-05-05T22:33:50Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 5, 2024, 10:33pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/1 "2024-05-05T22:33:50Z")
Hello. I’m having trouble combining equal values ​​and just displaying the last result of each combination in the data viewer. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/c/2c492f51b56e878ada7113d131c0f328fefa11fb.png) This is the table that contains some equal numbers, which I need to combine and display only the last one of each of them. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/4/44bcd803d53690b188d8268b41653b9c2357f949.png) I don’t know if I did it right, because I’m new to thunkable, but here is the function I tried to create to start a search. The goal is to display only the last value of each row that has the same number. I need a lot of help here. ---
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 5, 2024, 10:37pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/2 "2024-05-05T22:37:37Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/75873b822ab4cf96117645f66733f8a09287c16c.png) This is the app screen ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [May 17, 2024, 2:30pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/3 "2024-05-17T14:30:45Z")
HI @samir.henry3rz, thanks for your patience. Are you still having any trouble with this? ---
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 17, 2024, 2:42pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/4 "2024-05-17T14:42:19Z")
Yes, still looking for a solution, but without success. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [May 17, 2024, 4:21pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/5 "2024-05-17T16:21:21Z")
I don’t understand what you’re expecting the output to be. Can you provide a specific example from the screenshot above? What would the calculation contain and what would you expect the result to be? ---
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 17, 2024, 5:15pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/6 "2024-05-17T17:15:47Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/75873b822ab4cf96117645f66733f8a09287c16c.png) This is the complete result of the database. I want to combine results that contain the same number, leaving only the last result of each number. Here are three numbers, two of which are repeated, so of these two I only want their last result. I hope I explained it correctly. ---
**Author:** ![tiny\_apps](https://avatars.discourse-cdn.com/v4/letter/t/3d9bf3/32.png) [@tiny\_apps](https://community.thunkable.com/u/tiny_apps)\ **Post date:** [May 17, 2024, 5:40pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/7 "2024-05-17T17:40:10Z")
May be you can use this thread > [@Remove duplicate items from a list](https://community.thunkable.com/t/remove-duplicate-items-from-a-list/2760835/2): > > Here’s a demo: [Thunkable](https://x.thunkable.com/copy/2a3fd93a857e3d8b96276368d457bf64) (See the first screen) ---
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 17, 2024, 11:28pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/8 "2024-05-17T23:28:44Z")
As soon as I can I will test it. I’ll respond here soon. Thanks. ---
**Author:** ![tiny\_apps](https://avatars.discourse-cdn.com/v4/letter/t/3d9bf3/32.png) [@tiny\_apps](https://community.thunkable.com/u/tiny_apps)\ **Post date:** [May 18, 2024, 1:52am UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/9 "2024-05-18T01:52:07Z")
If you want last value from the list then you may need to modify the blocks… the block in that thread will store first value from the list… but the central idea remains the same. ---
**Author:** ![samir.henry3rz](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/samir.henry3rz/32/176572_2.png) [@samir.henry3rz](https://community.thunkable.com/u/samir.henry3rz)\ **Post date:** [May 23, 2024, 1:55pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/10 "2024-05-23T13:55:30Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/c/6c7cf83ef0d974a1fc2cf48668f83ad78f1d8215.jpeg) I tried to apply this logic in my context. I hope I’m correct. But I don’t know how to display this result in the dataviewer, because I need to get the data referring to the number saved in the database. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [August 21, 2024, 1:55pm UTC](https://community.thunkable.com/t/how-to-display-combined-values-in-the-data-viewer/2986482/11 "2024-08-21T13:55:33Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.