1
00:00:01,010 --> 00:00:07,220
In this video, you will learn about poverty and language, so this is the first video in the school's.

2
00:00:08,310 --> 00:00:10,810
But this I have imported one data set.

3
00:00:10,830 --> 00:00:17,220
This is the sales orders and let's go to the power to the editor.

4
00:00:18,010 --> 00:00:20,550
So we just need to click transform data.

5
00:00:23,360 --> 00:00:32,990
And this is a formula bar that contains a language code, and under setting you can see different applied

6
00:00:32,990 --> 00:00:41,700
steps for the first episode is so says the X File, and then the navigation formatted headers and change

7
00:00:41,870 --> 00:00:50,750
type for whenever we perform any operation in the poetry editor just by a like or a moving column,

8
00:00:50,750 --> 00:00:54,600
adding some rules are key or anything.

9
00:00:55,340 --> 00:00:59,880
So in the back in poverty, editors generate a language code.

10
00:01:00,320 --> 00:01:02,470
So this is what you can see here.

11
00:01:03,590 --> 00:01:09,110
And the other ways go like here you can see individual steps.

12
00:01:09,140 --> 00:01:12,710
They the code of every step you can see in the formula bar.

13
00:01:16,240 --> 00:01:24,370
And if we want to see the complete code in one editor for this, we have to click, advance, edit option

14
00:01:25,180 --> 00:01:25,740
this one.

15
00:01:25,750 --> 00:01:27,830
And here you can see this is the.

16
00:01:28,690 --> 00:01:34,140
It is start with let keyword and then you have to define all the variables here.

17
00:01:35,350 --> 00:01:44,770
And after this, when everything is done, then we need to close it by using in keyword.

18
00:01:45,190 --> 00:01:51,240
And at the end we have to use the last used variable that is changed.

19
00:01:52,300 --> 00:02:00,520
So every step here returns one table, for example, here you can see the output of these steps.

20
00:02:01,830 --> 00:02:08,760
Will be moved to the red tape, to this source, will be assigned to the source variable and then force

21
00:02:08,760 --> 00:02:10,680
need to be used in the second step.

22
00:02:10,980 --> 00:02:15,000
Look here, SCSI source.

23
00:02:15,930 --> 00:02:24,690
This is a source variable, and then the output of this step will be served in this order sheet, and

24
00:02:24,690 --> 00:02:27,680
then we have to use the sale order sheet in the third step.

25
00:02:27,720 --> 00:02:28,440
Here you can see.

26
00:02:29,670 --> 00:02:38,400
Sale order sheet, and in the same way the output of this step will be saved, will be are will be assigned

27
00:02:38,400 --> 00:02:43,470
to the promoted headers and then we have to use promoted headers in the fourth step.

28
00:02:45,210 --> 00:02:50,610
And at the end we got everything under change type.

29
00:02:51,570 --> 00:02:59,420
And we have to display after Inchy what we have to display the final variable that is changed type.

30
00:03:01,210 --> 00:03:12,600
So let's so let me click cancel and we just need to click, right, click and create one blanket.

31
00:03:13,420 --> 00:03:15,900
So let's fight some poor viral.

32
00:03:17,160 --> 00:03:25,620
And so because it is the formula bar and we need to go to the advanced Ed, so just click it was Ed.

33
00:03:27,720 --> 00:03:37,410
And here again, right here, X variable is equal to one, and then if this step is completed, then

34
00:03:37,410 --> 00:03:45,460
we need to write a comma that will show the step is completed and then we have to write the second variable,

35
00:03:45,460 --> 00:03:51,860
like Y is equal to X plus.

36
00:03:51,870 --> 00:03:59,220
But the output of this variable we have used in the second step, output of the second step is being

37
00:03:59,220 --> 00:04:01,870
assigned to the variable Y.

38
00:04:01,890 --> 00:04:04,050
And here we have to explain why.

39
00:04:07,570 --> 00:04:17,250
This one, and that's it, so click done and here you can see it's a one plus 12 is 13.

40
00:04:19,180 --> 00:04:21,290
So this is the answer.

41
00:04:21,670 --> 00:04:26,890
So and here you can see the first step is X, which is one.

42
00:04:27,010 --> 00:04:30,260
And then the second step is Y, which is X plus 12.

43
00:04:30,430 --> 00:04:32,130
And the answer is 13.

44
00:04:32,590 --> 00:04:39,250
So this is the simple syntax of poverty, very formal language or M language.

45
00:04:39,400 --> 00:04:45,850
And in this way, you will learn about how to use variables.

46
00:04:46,000 --> 00:04:54,490
For example, if I click advance editors and here you can see the first the the the name of the first

47
00:04:54,490 --> 00:04:55,510
variable source.

48
00:04:55,510 --> 00:04:59,830
And the second is, is a hash double sale order sheet.

49
00:05:00,550 --> 00:05:09,250
So whenever we have spaces in the variable name, then the syntax will be hash doublecross in the name

50
00:05:09,250 --> 00:05:11,510
of the variable that contain spaces.

51
00:05:12,370 --> 00:05:19,510
So if I remove this space like a sale order, if I remove the space and then we have to remove, um,

52
00:05:19,690 --> 00:05:22,780
like a double this or.

53
00:05:25,010 --> 00:05:33,080
This one, and then we can use sell orders, then we I mean, we if we don't have any speed, then we

54
00:05:33,080 --> 00:05:39,170
don't need to use Heshan the courts and we have to use sell order sheet.

55
00:05:40,140 --> 00:05:43,770
And the next step, which is this one.

56
00:05:46,360 --> 00:05:52,360
And the same way, if I change, like, promoted high school to beheaders.

57
00:05:57,160 --> 00:05:57,640
Copy.

58
00:05:58,090 --> 00:05:59,320
And then we have to use here.

59
00:06:04,080 --> 00:06:05,310
And in the same way.

60
00:06:06,610 --> 00:06:07,060
Like.

61
00:06:09,370 --> 00:06:15,910
See type, we have to remove the space and that's it, and then we have to use.

62
00:06:18,300 --> 00:06:19,290
See type here.

63
00:06:28,480 --> 00:06:29,320
So that's it.

64
00:06:29,860 --> 00:06:33,250
So we need to click done and here you can see.

65
00:06:35,120 --> 00:06:43,340
There is no end and we are able to change the name of the the variables, so if you click here like

66
00:06:43,580 --> 00:06:53,810
navigation and know the name is previously it was promoted as headers and orders, beheaders and the

67
00:06:53,810 --> 00:06:58,510
name of CTD such change type and notice C type.

68
00:06:59,210 --> 00:07:07,700
So whatever we were put here, the name of the variable, it will be displayed under applied steps,

69
00:07:07,960 --> 00:07:09,380
the individual steps.

70
00:07:11,890 --> 00:07:16,060
So this is the small introduction about how we can use.

71
00:07:17,390 --> 00:07:24,140
Poverty free formula here, you can see in the poverty, Ed, we have different options that are available

72
00:07:24,140 --> 00:07:32,030
like much Curis a painkiller is used as head of whenever we click or we use any feature in the back.

73
00:07:32,210 --> 00:07:33,470
We got encode.

74
00:07:34,040 --> 00:07:44,000
And in some situations, these features, these features are not enough to resolve or transform the

75
00:07:44,000 --> 00:07:44,340
data.

76
00:07:45,110 --> 00:07:52,100
So for this, we have to be very comfortable with the other and language.

77
00:07:54,630 --> 00:08:03,660
So in the future lecture, we will slowly proceed and we will try to do all the available features of

78
00:08:04,110 --> 00:08:13,350
our duty formula language and where we have to use any language in any case we have to use.

79
00:08:14,100 --> 00:08:19,250
So what will be those situations you will see in the coming videos?