Hola a todos
Hace 2 semanas exporto código M como se muestra a continuación, puedo ver el guión rojo de luz alta :-
Dejar
Origen = SharePoint.Files("https://isdnholdings.sharepoint.com/sites/FT_AR/", [ApiVersion = 15]),
#"Filas filtradas" = Table.SelectRows(Source, cada una ([Nombre] = "AR_TS_O.csv")),
#"AR_TS_O csv_https://isdnholdings sharepoint com/sites/FT_AR/Shared Documents/" = #"Filtered Rows"{[Name="AR_TS_O.csv",#"Folder Path"="https://isdnholdings.sharepoint.com/sites/FT_AR/Shared Documents/"]}[Content],
#"CSV importado" = Csv.Document(#"AR_TS_O csv_https://isdnholdings sharepoint com/sites/FT_AR/Shared Documents/",[Delimiter=",", Columns=12, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Encabezados promocionados" = Table.PromoteHeaders(#"CSV importado", [PromoteAllScalars=true]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promocionados",{{"Customer/Vendor Code", escriba text}, {"Customer/Vendor Name", escriba text}, {"AgeingDate", Int64.Type}, {"A/R amount include GST in LC", type number}, {"Ar Invoice Date", type date}, {"AR Invoice Number", Int64.Type}, {"SalesPerson", type text}, {"SlpName", type text}, {"Industry_Description", type text}, {"CustClass", Int64.Type}, {"Payment Terms Code", type text}, {"CreditLine", Int64.Type}})
En
#"Tipo cambiado"
Hoy en día, cuando exporto me pondí a continuación, no puedo ver el script CSV #imported :-
Dejar
Origen = SharePoint.Files("https://isdnholdings.sharepoint.com/sites/FT_AR/", [ApiVersion = 15]),
#"Archivos ocultos filtrados1" = Table.SelectRows(Source, each [Attributes]?[ ¿Escondido]? <> verdadero),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (9)", cada #"Transform File (9)"([Content])),
#"Columnas renombradas1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (9)"}),
#"Columna de tabla expandida1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (9)", Table.ColumnNames(#"Transform File (9)"(#"Sample File (9)"))),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", escriba text}, {"Customer/Vendor Code", escriba text}, {"Customer/Vendor Name", type text}, {"AgeingDate", Int64.Type}, {"A/R amount include GST in LC", type number}, {"Ar Invoice Date", type date}, {"AR Invoice Number", Int64.Type}, {"SalesPerson", type text}, {"SlpName", type text}, {"Industry_Description", type text}, {"CustClass", type text}, {"Payment Terms Code", Int64.Type}, {"CreditLine", Int64.Type}})
En
#"Tipo cambiado"
¿Puedo saber por qué?
Paul Yeo
