第二章的主题为在最大层数MaxLv未知的情况下构建和展开路径图,在开始之前需要讲解如何使用生成数据(第一章节的内容)的附件。首先,请把附件中Data文件夹解压至C:\中。然后,请按以下表格的指示更新文[......]
Parent Child Hierarchies (I)
本文将延续施阳老师的《BOM树形结构分解》,细化路径图的构造以及展开。由于篇幅的缘故,所有的内容将分为多个章节进行讲解。第一章节的主题为通过M语言构造用于分析的数据。
Group1Group2L[......]
Table.Split()
Table.Split()可以抽象地概括为function(table as table, pageSize as number) as list,大概的意思为这个函数的第一个参数为需要进行自上而下地[......]
Table.Schema()
Table.Schema()的唯一参数的数据类型为表格。该函数的结果为一表格,其第一列从上至下的文本值对应参数表从左到右的字段名称。从第二列开始,每一列中的值为同一行的第一列中的文本值对应于参数表中的[......]
Table.SelectColumns()
Table.SelelctColumns()可以抽象地概括为function(table as table, columns as any, optional missingField as null[......]
Table.ReorderColumns()
Table.ReorderColumns()可以抽象地概括为function(table as table, columnOrder as list, optional missingField as[......]
Table.Profile()
Table.Profile()可以抽象地概括为function(table as table, optional addtionalAggregates as nullable list) as ta[......]
Table.Sort()
Table.Sort()可以抽象地概括为function(table as table, comparisonCriteria as any) as table,大概的意思为该函数的第一个参数为需要进[......]
Table.AddJoinColumn()
Table.AddJoinColumn()可以抽象地概括为function(table1 as table, key1 as any, table2 as any, key2 as any, newC[......]
Table.AddKey()
Table.AddKey()可以抽象地概括为function(table as table, columns as list, isPrimary as logical) as table,意思为该函[......]