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 ...
General Comment
Need Help
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