Forum Discussion

Monica's avatar
Monica
Frequent Visitor
10 years ago

Unexpected Error with the new version

Hi!

 

I just changed a text in a custom colom then this error window, now if I open the model this appear:

 

But then this change to this window, wich doesn't stop to appear, if I move the moause it appear!! And I don't know what is the error. Plus, I can't do nothig becuase the window doesn't stop..

 

 

It never happened to me beffore, I don't know if is somethig with the new version, but I need to finish this ASAP. Please some could help me??

 

MiguelMartinez

ankitpatira

Greg_Deckler

Sean

Anonymous

LanceDelano

Anonymous

 

General Comment
Need Help

2 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    What is in this custom column? and what data type is it?

     

    • Monica's avatar
      Monica
      Frequent Visitor
      10 years ago

      Look this image, the name is "MARCA 2", is a column just with text:

       

      This is the query:

      let
    Origen = Excel.Workbook(File.Contents("C:\Users\mmcarvajal\Desktop\MONICA\BRAND SCIENCE\2016\Proyectos\Une Home\Data\LLAMADAS Requeridas Entrada Contact Center (19-04-2016) LAPSOS X HORA.XLSX"), null, true),
    #"MODELO TRÁFICO_Sheet" = Origen{[Item="MODELO TRÁFICO BRAND SCIENCE",Kind="Sheet"]}[Data],
    #"Tipo cambiado" = Table.TransformColumnTypes(#"MODELO TRÁFICO_Sheet",{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, {"Column4", type any}, {"Column5", type any}}),
    #"Filas en blanco eliminadas" = Table.SelectRows(#"Tipo cambiado", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    #"Removed Other Columns" = Table.SelectColumns(#"Filas en blanco eliminadas",{"Column5", "Column4", "Column3", "Column2", "Column1"}),
    #"Removed Top Rows" = Table.Skip(#"Removed Other Columns",1),
    #"Encabezados promovidos" = Table.PromoteHeaders(#"Removed Top Rows"),
    #"Filas filtradas" = Table.SelectRows(#"Encabezados promovidos", each ([#"Fecha (yyyy-mm-dd)"] <> "Total general")),
    #"Tipo cambiado1" = Table.TransformColumnTypes(#"Filas filtradas",{{"Hora (hh:mm/24 horas)", type time}, {"Fecha (yyyy-mm-dd)", type date}, {"Numero de Llamadas venta", Int64.Type}}),
    #"Personalizada agregada" = Table.AddColumn(#"Tipo cambiado1", "MARCA 2", each "TIGO/UNE llamadas"),
    #"Personalizada agregada1" = Table.AddColumn(#"Personalizada agregada", "Variable.Fuente", each "Llamadas.Une"),
    #"Columnas con nombre cambiado" = Table.RenameColumns(#"Personalizada agregada1",{{"Fecha (yyyy-mm-dd)", "Date"}, {"Hora (hh:mm/24 horas)", "Hora"}}),
    #"Columna combinada insertada" = Table.AddColumn(#"Columnas con nombre cambiado", "Key", each Text.Combine({[Variable.Fuente], Text.From([Date], "es-CO"), [MARCA 2],[Región], Text.From([Hora], "es-CO")}, ""), type text)
in
    #"Columna combinada insertada"

      Thanks