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
You can use Table.Buffer for this problem.
Copy and paste the following code in Advanced Editor to see how.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkktKkpMzlfSUTI2N7EMC/QEsopTi8oyk1OVYnWildzzc9KAQhbG5oYBPv5AVnpiUWI6VC7E1MAAKGRkYGzm6huKptO3NKcksyAnEWS0qYWht5szqu6AxKzUIpDFhqbGhkG+bqiyzvl5IJ1mRoaWIW5eqHJBjmEmIDljI1NHnzA0ax2DI4AiJgbmhsFeUYQ8gyyJYSNcMhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Model = _t, #"Registration " = _t, Status = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Model", type text}, {"Registration ", type text}, {"Status", type text}}),
#"Sorted Rows" = Table.Buffer(Table.Sort(#"Changed Type",{{"Status", Order.Descending}})),
#"Removed Duplicates" = Table.Distinct(#"Sorted Rows", {"Model", "Registration "})
in
#"Removed Duplicates"