Forum Discussion
Solved
Extract Certain Users
Hello Experts, I have some user reports, in some cases the system assigns a chain of people for tracking, however I only need to assign a person the closure of said event to follow up, and I would no...
Hi Anonymous
Please refer to sample file with the solution https://www.dropbox.com/t/8vsnZ9m7YnzmWJDyFinal User = VAR QualifiedUsers = VALUES ( 'Follow Up'[User Failure Follow Up] ) VAR CurrentUsers = Failures[User] VAR ConvertToPath = SUBSTITUTE ( CurrentUsers, ", ", "|" ) VAR T1 = GENERATESERIES ( 1, PATHLENGTH ( ConvertToPath ), 1 ) VAR T2 = ADDCOLUMNS ( T1, "@User", PATHITEM ( ConvertToPath, [Value] ) ) VAR AllUsers = SELECTCOLUMNS ( T2, "User", [@User] ) VAR T3 = INTERSECT ( AllUsers, QualifiedUsers ) VAR NumOfQualifiedUsers = COUNTROWS ( T3 ) VAR FinalUsers = CONCATENATEX ( T3, [User], "|" ) VAR FinalUser = PATHITEM ( FinalUsers, 1 ) RETURN FinalUser
Admin, here you can find the edit data with the expected results.
Failure User
| 1122 | Luciano Martinez |
| 1123 | Camilo Sexto, Alfonzo Hernandez, Pedro Lopez, Martin Fiero, Lautaro Fernandez |
| 1234 | Martin Fiero |
| 2432 | Camilo Sexto, Lautaro Fernandez, Pedro Lopez |
| 2488 | Alfonzo Hernandez |
| 2892 | Pedro Lopez, Alfonzo Hernandez, Martin Fiero, Lautaro Fernandez, Camilo Sexto |
| 3296 | Lautaro Fernandez |
| 3700 | Alfonzo Hernandez |
| 4104 | Leonardo Castillo |
| 4509 | Juan Castro |
User Failure Follow Up
| Juan Castro |
| Luciano Martinez |
| Martin Fiero |
| Lautaro Fernandez |
| Leonardo Castillo |
| Leonardo Semprum |
| Alfonzo Hernandez |
| Carlos Ruiz |
| Estefania Solis |
| Julio Estrada |
Failure User
| Final Data Example | |
| 1122 | Luciano Martinez |
| 1123 | Alfonzo Hernandez |
| 1234 | Martin Fiero |
| 2432 | Lautaro Fernandez |
| 2488 | Alfonzo Hernandez |
| 2892 | Martin Fiero |
| 3296 | Lautaro Fernandez |
| 3700 | Alfonzo Hernandez |
| 4104 | Leonardo Castillo |
| 4509 | Juan Castro |
Please let me know if that is clear.
Regards