Forum Discussion

alejandroezp's avatar
alejandroezp
Icon for Helper I rankHelper I
1 year ago
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...
Need Help
Tips and Tricks
Tutorial Requests
  • vivien57's avatar
    vivien57
    1 year ago

    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

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
1 year ago

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 ->