In this video, you will learn about poverty and language, so this is the first video in the school's.
But this I have imported one data set.
This is the sales orders and let's go to the power to the editor.
So we just need to click transform data.
And this is a formula bar that contains a language code, and under setting you can see different applied
steps for the first episode is so says the X File, and then the navigation formatted headers and change
type for whenever we perform any operation in the poetry editor just by a like or a moving column,
adding some rules are key or anything.
So in the back in poverty, editors generate a language code.
So this is what you can see here.
And the other ways go like here you can see individual steps.
They the code of every step you can see in the formula bar.
And if we want to see the complete code in one editor for this, we have to click, advance, edit option
this one.
And here you can see this is the.
It is start with let keyword and then you have to define all the variables here.
And after this, when everything is done, then we need to close it by using in keyword.
And at the end we have to use the last used variable that is changed.
So every step here returns one table, for example, here you can see the output of these steps.
Will be moved to the red tape, to this source, will be assigned to the source variable and then force
need to be used in the second step.
Look here, SCSI source.
This is a source variable, and then the output of this step will be served in this order sheet, and
then we have to use the sale order sheet in the third step.
Here you can see.
Sale order sheet, and in the same way the output of this step will be saved, will be are will be assigned
to the promoted headers and then we have to use promoted headers in the fourth step.
And at the end we got everything under change type.
And we have to display after Inchy what we have to display the final variable that is changed type.
So let's so let me click cancel and we just need to click, right, click and create one blanket.
So let's fight some poor viral.
And so because it is the formula bar and we need to go to the advanced Ed, so just click it was Ed.
And here again, right here, X variable is equal to one, and then if this step is completed, then
we need to write a comma that will show the step is completed and then we have to write the second variable,
like Y is equal to X plus.
But the output of this variable we have used in the second step, output of the second step is being
assigned to the variable Y.
And here we have to explain why.
This one, and that's it, so click done and here you can see it's a one plus 12 is 13.
So this is the answer.
So and here you can see the first step is X, which is one.
And then the second step is Y, which is X plus 12.
And the answer is 13.
So this is the simple syntax of poverty, very formal language or M language.
And in this way, you will learn about how to use variables.
For example, if I click advance editors and here you can see the first the the the name of the first
variable source.
And the second is, is a hash double sale order sheet.
So whenever we have spaces in the variable name, then the syntax will be hash doublecross in the name
of the variable that contain spaces.
So if I remove this space like a sale order, if I remove the space and then we have to remove, um,
like a double this or.
This one, and then we can use sell orders, then we I mean, we if we don't have any speed, then we
don't need to use Heshan the courts and we have to use sell order sheet.
And the next step, which is this one.
And the same way, if I change, like, promoted high school to beheaders.
Copy.
And then we have to use here.
And in the same way.
Like.
See type, we have to remove the space and that's it, and then we have to use.
See type here.
So that's it.
So we need to click done and here you can see.
There is no end and we are able to change the name of the the variables, so if you click here like
navigation and know the name is previously it was promoted as headers and orders, beheaders and the
name of CTD such change type and notice C type.
So whatever we were put here, the name of the variable, it will be displayed under applied steps,
the individual steps.
So this is the small introduction about how we can use.
Poverty free formula here, you can see in the poverty, Ed, we have different options that are available
like much Curis a painkiller is used as head of whenever we click or we use any feature in the back.
We got encode.
And in some situations, these features, these features are not enough to resolve or transform the
data.
So for this, we have to be very comfortable with the other and language.
So in the future lecture, we will slowly proceed and we will try to do all the available features of
our duty formula language and where we have to use any language in any case we have to use.
So what will be those situations you will see in the coming videos?