Forum Discussion
Solved
Import files filtered by preferences
Good morning, I have a car history with the model, registration and status of each car. But, some people access to this file and edit it. When I try to cross-reference this file with another fil...
Hello alejandroezp ,
It depends on why they are still there. In my opinion, it is because the data must follow a different scenario than the one initially mentioned.
Have a nice day,
Vivien
Add this step to your query...
= Table.Group(previousStepName, {"Model", "Registration "}, {{"Status", each if Table.RowCount(_) = 1 then _[Status]{0} else List.Select(_[Status], each _ = "service"){0}, type text}})Change 'previousStepName' to the name of your previous step.
Start->
Finish ->
Good morning,
I tried your suggestion and duplicate cars appeared, and the rest of the process failed.
Best regards, and thank you very much for all the help.