Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New help with row counts

hello from this table I have repeated [Puesto] but with different [Agrupador] I need to create another table with only the ones repeated with their respective [Agrupador] how can i do this in power Query? note:this is sample data

 

 

57AFANADOR S (TC)Administración
58AGENTE ATENCION TELEFONICA MULTISKILLCheca
59AGENTE ATENCION TELEFONICA PAGOSCheca
60AGENTE ATENCION TELEFONICA RETENCIONCheca
61AGENTE ATENCION TELEFONICA TECNICOCheca
62AGENTE ATENCION TELEFONICA TECNICO CABLE ACCESSCheca
63AGENTE ATENCION TELEFONICA TECNICO TELEFONIACheca
64AGENTE ATENCION TELEFONICA VENTASCheca
65AGENTE ATN. TELEFONICA MULTISKILLCheca
66AGENTE ATN. TELEFONICA PAGOS MTCheca
67AGENTE ATN. TELEFONICA PYMECheca
68AGENTE ATN. TELEFONICA TEC.Atencion a Clientes
69AGENTE ATN. TELEFONICA TELECOM MTCheca
70AGENTE ATN. TELEFONICA VENTASCheca
71AGENTE CAS (TVI)Administración
72AGENTE CAS PREMIUM (TVI)Administración
73AGENTE DISPATCH (TVI)Monitores
74AGENTE SERV. CLIENTE (TVI)Checa
75AGENTE SERV. CLIENTE 2 NIVEL (TVI)Checa
76AGENTE SUC. (TVI)Administración
77AGENTE SUC. (TVI)Atencion a Clientes
78AGENTE SUC. (TVI)Ventas
79AGENTE SUC. INCAPACIDAD (TVI)Atencion a Clientes
80AGENTE VALIDACION IZZI (TVI)Checa
81AGTE. ATN. TELEFON. TEC. CABLE ACCESSCheca
82ALMACENISTAAdministración
83ALMACENISTA (CM)Administración
84ALMACENISTA (TC)Administración
85ALMACENISTA (TVI)Administración
86ALMACENISTA A (CC)Administración
87ALMACENISTA B (CC)Administración
88ALMACENISTA B (CC)Administración
89ALMACENISTA DESPACHADOR (CM)Administración
General Comment
Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    sorry [Puesto] is the second Column and [Agrupador] the third one

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Group the table by [Puesto] & [Agrupador] in power query .

     

    For more details, please check M code as below.

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lZXRTsIwFIZfpdmVJmRRBFouj2cVGtuObGWJGi8ILnGJjgR4Mx/BF7MbaNZJK14ttN+3nZ7/bDw9RWMaDSK4Aw1JmpGcXBi8bFZe3qu62u23q3X1+VFHzwOLsmZjxrXhBAzXKFJNDJf8LtUCgailNCK/F1JaDl/L9eqgTcPaAmZp7hiTq7CR8eOia12HLcPRXlPXGZ7lEIRbaQlEnvdKvTnvBt9L4NqjsF3YHeg9cNxVdHxGAJOJX2mbT5RxBRoQHhR3YeaH7enjZndf1utqU5MVwbeqrPfl7qBOQ6rkmKp+afTKr5zoFu3MBEIz3YXwjTcduuwi40osVdjpxJ+IfAEG5z+C2tTVfrM9HpZ2ss55VsQEpWh/ffOdssc+dki0KLg85XRSzpcYh+umPtgTFWUeobDM6shMe4zQCAtAkUDy5wNYJ9gCpHXal0E8PooTh2WHXA2PnSmI24nzv62sjVgqQK5FbsDTHXbjYuQCla+TbNRn/R9QNv7F+iNikx7clOG/Ne3Rt0Ga/Yue9uiE20nHefuP4WvN8xc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Puesto = _t, Agrupador = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Puesto", type text}, {"Agrupador", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Puesto", "Agrupador"}, {{"Count", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"

     

     

    If it doesn't meet your requirement, kindly share your excepted result to me.