|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/powerquery-m-code-language-part4/
课程评论：没有评论
**Coursera课程总结：PowerQuery M语言 Part 4** 本课程是 M 语言系列的高阶课程，专为已有列表、函数和 M 语言语法基础的学习者设计。课程的核心内容是深入讲解 `List.Generate` 函数，并展示其在实际应用中的多种用法。 **课程亮点：** * **`List.Generate` 函数详解：** * 深入剖析 `List.Generate` 函数的构成，包括初始值、条件、执行以及一个学生常常忽略的“隐藏”参数。 * 详细解释每个参数的作用，以及如何处理多变量（两个或更多）的生成过程。 * 讲解如何理解和使用方括号、逗号等语法元素，尤其是在处理数据时。 * 探索 `List.Generate` 函数中的可选参数及其工作原理。 * **实践应用技巧：** * 演示如何将 `List.Generate` 函数转化为可复用的自定义函数，并与实际数据集成。 * 介绍并实操 `Table.Sort`、`Table.SelectColumns` 和 `Table.SelectRows` 等常用表格函数。 * 教授如何使用 M 语言将两个列合并成新的序列。 * 探讨在解决实际问题时，是采用函数化方法还是非函数化方法更优。 本课程将帮助您掌握 `List.Generate` 函数这一强大的 M 语言工具，并提升您在 Power Query 中处理和转换数据的能力。
Please note that if you have seen previous Parts of M code series then only it will be a fun and clarity. This part 4 is not for beginers. If you know how to use lists, functions and how to write syntax in m code, pls go ahead and take this course.M code Part4 is talking about List.genrate function and how to use it as a function in real life plus other functions also in focuss.Introducing the list generate function in M code.What is a list generate function and how its parameters workWhat is the initial parameter, what is the conditional parameter and execution parameter?How to use list generate function using two variables or even more than two variables and how to know the number of variables we have to use.We have started from a beginning and have tried to explain the Concept of this function is clear step by step.There is a 4th hidden parameter which students never see and infact , even they know they don't know how to use it and what is the use of same.What is the role of an optional parameter in list generate function and how does it work.How to know where do we use square brackets , commas especially in a code where it is using data.How to convert list generate into a function which takes inputs and then connect it with the real dataTable sort function in real dataTable select column functionTable select rows functionHow to combine two columns in a sequence using Mcode interface.How to approach a problem - with function and without function - which one is better
