Forum Discussion
Helper ITying values to a unique identifier
Hello!
I have attached a picture showing the scenario I face. I export a .csv sheet that has 4 columns. One has a generic name that is repeated every time a new identifier appears in column 2. Two has a unique ID, the third column has the employee id, and the fourth has the hours worked.
The issue is that the unique identifier only shows in one row therefore only times to the first entry in column three and 4. All other employees and their subsequent hours do not have a unique identifier and can not be joined properly to the other table I desire to join to.
Is there a way to solve this when I edit my query? It will be a monthly report so I am hoping there is a way!
Thank you for any feed back !
| Description | ID | Employee | Hours |
| Repair_details | 15625.0s | Employee 1 | 0.5 |
| Employee 2 | 1 | ||
| Employee 3 | 1 | ||
| Repair_details | 15768.0t | Employee 5 | 0.5 |
| Employee 3 | 0.5 | ||
| Employee 2 | 0.5 | ||
| Repair_details | 157869.0h | Employee 5 | 1.5 |
| Employee 2 | 1 | ||
| Employee 1 | 1.5 |
5 Replies
Js112233Hey! Thank you! This is so incredibly easy I feel sheepish. Thought about it too hard I guess. Thank you!
- Js112233
When you say refresh works too, does that mean in a month from now when I replace the CSV the old ones will fill in correctly and the newly added data (that will have new IDs) will just need to be filled in?
SeanCommunity Champion
I first created a sample Excel file with the data you had posted.
Then I just added 5 additional rows to the sample data as in the picture - saved and closed Excel as is in the Picture below
Then in PBI hit Refresh and this is the updated result!
Good Luck! :smileyhappy: