Forum Discussion
Solved
Filter Unique
Hi All sorry to ask what must be a simple question. I have data that is collected by scaning in and out items from a stock. Each time it is scaned in, and then again out a new record is crea...
Here you go
| 4 | 0f6f2427-07a9-4f72-8922-38eecdbeb224 | [email protected] | 2018-07-01 13:54:51.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 13:52:57.000 | 2018-07-01 13:54:51.000 | NULL | 2018-07-01 13:52:57.000 | Check Out | Assigned | Gavin Fisher | CPower Kit Bag 02 | NULL | Harness 40058 | Frog 171918170885 | Work Positioner 20810009 / 032 | Fall Aresst 20814693 / 014 | Life JKT R500304 | NULL | NULL | NULL | Immersion Suite 3841089055 | 2 |
| 5 | cbaefadb-37bb-46b5-b891-da26043c8825 | [email protected] | 2018-07-01 14:00:46.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 13:55:04.000 | 2018-07-01 14:00:46.000 | NULL | 2018-07-01 13:55:05.000 | Check Out | Assigned | Jamie Walton | CPower Kit Bag 14 | NULL | Harnress 38780 | Frog 171918171447 | Work Positioner 20745277 / 055 | Fall Arrest 208146938 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082935 | 2 |
| 6 | aa8d1c6c-93a6-478a-9e8c-e64e34af08d9 | [email protected] | 2018-07-01 14:09:23.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:01:35.000 | 2018-07-01 14:09:23.000 | NULL | 2018-07-01 14:01:36.000 | Check Out | Assigned | Craig Raffle | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
| 7 | 48f5726d-10c9-484e-8fec-79453029b516 | [email protected] | 2018-07-01 14:14:14.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:09:49.000 | 2018-07-01 14:14:14.000 | NULL | 2018-07-01 14:09:53.000 | Check Out | Assigned | Mark Instance | CPower Kit Bag 1 | NULL | Harness 37331 | Frog 171918171454 | Work Positioner 20732946/098 | Fall Arest 20750662/003 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841087857 | 2 |
| 8 | 4acc2081-11d8-4502-b86a-9380841b2bec | [email protected] | 2018-07-01 14:34:10.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:30:13.000 | 2018-07-01 14:34:10.000 | NULL | 2018-07-01 14:30:13.000 | Check Out | Assigned | Anthony Price | Cpower Kit Bag 08 | NULL | Harness 38223 | Frog 171918171085 | Work Positioner 20727089 / 008 | Fall Arrest 20750662 / 006 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089037 | 2 |
| 9 | 0f068299-e689-428b-97e6-24db79d1ca29 | [email protected] | 2018-07-01 14:35:53.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:34:16.000 | 2018-07-01 14:35:53.000 | NULL | 2018-07-01 14:34:17.000 | Check Out | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | NULL | 2 |
| 10 | 0e506f29-f8e2-4f99-89b3-c977f18edec4 | [email protected] | 2018-07-01 14:37:56.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:36:05.000 | 2018-07-01 14:37:56.000 | NULL | 2018-07-01 14:36:05.000 | Check Out | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | Frog 171918171465 | Work Positioner 20727089 / 015 | Fall Arrest 20750662 / 008 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suite 3841082937 | 2 |
| 11 | 0f068299-e689-428b-97e6-24db79d1ca29 | [email protected] | 2018-07-01 14:45:06.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 1895328 | NULL | 2018-07-01 14:44:35.000 | 2018-07-01 14:45:06.000 | NULL | 2018-07-01 14:34:17.000 | Check Out | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841082680 | 2 |
| 12 | 2a977e69-b838-4829-bc26-ec11d4c7af88 | [email protected] | 2018-07-03 12:16:14.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 14_Check inJamie Walton | 0 | NULL | 2018-07-03 12:13:49.000 | 2018-07-03 12:16:14.000 | NULL | 2018-07-03 12:13:49.000 | Check in | Assigned | Jamie Walton | CPower Kit Bag 14 | NULL | Harnress 38780 | Frog 171918171447 | Work Positioner 20745277 / 055 | Fall Arrest 208146938 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082935 | 2 |
| 13 | f1842123-5e04-4586-a8da-a326e3925f30 | [email protected] | 2018-07-03 12:18:22.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 1 _Check inMark Instance | 0 | NULL | 2018-07-03 12:16:39.000 | 2018-07-03 12:18:22.000 | NULL | 2018-07-03 12:16:39.000 | Check in | Assigned | Mark Instance | CPower Kit Bag 1 | NULL | Harness 37331 | Frog 171918171454 | Work Positioner 20732946/098 | Fall Arest 20750662/003 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841087857 | 2 |
| 14 | b890e44d-f91e-4707-a7f6-203d9210e4aa | [email protected] | 2018-07-03 12:24:46.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 04_Check inMarc Asif | 0 | NULL | 2018-07-03 12:20:02.000 | 2018-07-03 12:24:46.000 | NULL | 2018-07-03 12:20:03.000 | Check in | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | Frog 171918171465 | Work Positioner 20727089 / 015 | Fall Arrest 20750662 / 008 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suite 3841082937 | 2 |
| 15 | 5eec4eaa-52e0-4934-aea5-832d9885ea57 | [email protected] | 2018-07-03 12:26:45.000 | PPE Kit Bag Check in / Out | 29 | Cpower Kit Bag 11_Check inCraig Price | 0 | NULL | 2018-07-03 12:24:59.000 | 2018-07-03 12:26:45.000 | NULL | 2018-07-03 12:25:00.000 | Check in | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841082680 | 2 |
| 16 | a483f66d-bd4c-42f1-8ea2-da8384ef31e3 | [email protected] | 2018-07-03 12:29:16.000 | PPE Kit Bag Check in / Out | 29 | Cpower Kit Bag 08_Check inAnthony Price | 0 | NULL | 2018-07-03 12:26:57.000 | 2018-07-03 12:29:16.000 | NULL | 2018-07-03 12:26:57.000 | Check in | Assigned | Anthony Price | Cpower Kit Bag 08 | NULL | Harness 38223 | Frog 171918171085 | Work Positioner 20727089 / 008 | Fall Arrest 20750662 / 006 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089037 | 2 |
| 17 | 4e7a3873-665d-4d1d-a9f3-2adac68b6381 | [email protected] | 2018-07-03 12:29:25.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 04_Check inMarc Asif | 0 | NULL | 2018-07-03 12:18:30.000 | 2018-07-03 12:29:25.000 | NULL | 2018-07-03 12:18:30.000 | Check in | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 18 | 9ff928ba-026d-47e3-896a-107e0d04237b | [email protected] | 2018-07-03 12:34:15.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 10_Check inCraig Raffle | 0 | NULL | 2018-07-03 12:32:38.000 | 2018-07-03 12:34:15.000 | NULL | 2018-07-03 12:32:39.000 | Check in | Assigned | Craig Raffle | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
| 19 | d1f125e5-7dea-4779-8062-a895f23db4e3 | [email protected] | 2018-07-03 12:37:39.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 02_Check inGavin Fisher | 0 | NULL | 2018-07-03 12:35:39.000 | 2018-07-03 12:37:39.000 | NULL | 2018-07-03 12:35:39.000 | Check in | Assigned | Gavin Fisher | CPower Kit Bag 02 | NULL | Harness 40058 | Frog 171918170885 | Work Positioner 20810009 / 032 | Fall Aresst 20814693 / 014 | Life JKT R500304 | NULL | NULL | NULL | Immersion Suite 3841089055 | 2 |
| 20 | 7349bbbf-aec7-4946-8b66-b1b82ee25362 | [email protected] | 2018-07-04 11:36:44.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 10_Check OutRob Mackie | 0 | NULL | 2018-07-04 11:33:12.000 | 2018-07-04 11:36:44.000 | NULL | 2018-07-04 11:33:12.000 | Check Out | Assigned | Rob Mackie | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
| 21 | 6a4a3636-abaf-48e2-9101-a80466588db2 | [email protected] | 2018-07-04 12:42:32.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 19_Check OutWilliam Cook | 0 | NULL | 2018-07-04 12:37:18.000 | 2018-07-04 12:42:32.000 | NULL | 2018-07-04 12:37:19.000 | Check Out | Assigned | William Cook | CPower Kit Bag 19 | NULL | Harness 39961 | Frog 171918171467 | Work POsitioner 20810009 / 037 | Fall Arrest 20811932 / 024 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089143 | 2 |
| 22 | bf997e5f-9508-4607-8bbe-e735756c2435 | [email protected] | 2018-07-04 12:47:00.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 03_Check OutScott Walton | 0 | NULL | 2018-07-04 12:43:02.000 | 2018-07-04 12:47:00.000 | NULL | 2018-07-04 12:43:02.000 | Check Out | Assigned | Scott Walton | CPower Kit Bag 03 | NULL | Harness 39041 | Frog 171918171291 | Work Positioner 20727089 / 003 | Fall Arresst 20750662 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082646 | 1 |
| 23 | de71cacd-fee9-4c9c-83a5-d56cb359a30b | [email protected] | 2018-07-04 12:50:40.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 09_Check OutMartin Cosker | 0 | NULL | 2018-07-04 12:49:02.000 | 2018-07-04 12:50:40.000 | NULL | 2018-07-04 12:49:03.000 | Check Out | Assigned | Martin Cosker | CPower Kit Bag 09 | NULL | Harrness 39952 | Frog 171590170086 | WOrk Positioner 20776496 / 025 | Fall Arrest 20804105 / 026 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841089017 | 2 |
| 24 | c95d6788-4219-4998-8aa8-9ac060aeb740 | [email protected] | 2018-07-04 12:58:47.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 24_Check OutKarl Glover | 0 | NULL | 2018-07-04 12:55:04.000 | 2018-07-04 12:58:47.000 | NULL | 2018-07-04 12:55:04.000 | Check Out | Assigned | Karl Glover | CPower Kit Bag 24 | NULL | Harness 39968 | Frog 171590170153 | Work Positioner 207764964 / 030 | Fall Aresst 20797196 / 032 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841088834 | 1 |
| 25 | d2c771f7-0542-4b12-9293-264a96da63a7 | [email protected] | 2018-07-04 13:01:28.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 07_Check OutStu Macleod | 0 | NULL | 2018-07-04 12:59:07.000 | 2018-07-04 13:01:28.000 | NULL | 2018-07-04 12:59:07.000 | Check Out | Assigned | Stu Macleod | CPower Kit Bag 07 | NULL | Harness 37333 | Frog 171590170032 | Work Positioner 20776496 / 023 | Fall Arrest 20797196 / 003 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suit 3841088783 | 2 |
Hi Colinu,
Above data model is not readable to us as we are not familiar with your scenario. Please post some dummy data with each column name, but just contains necessary columns. And show us your desired output to help us better understand your requirement.
Regards,
Yuliana Gu