Create Flag in script

[stephenedberkg]

i have monthid and lock period as 2,3,0.

i have ID with month id and lock period.each id have the different lock period

i want to add this lock period with month id and to create flag for each lock period

like

month id  lock period               MonthIDs

1                  2                         3

2                  2                         4

3                   2                        5

4                   2                         6

5                  2                         7

1                 0                         1

2                 0                         2

3                  0                        3

4                  0                         4

5                  0                         5

1                 3                         4

2                3                         5

3                  3                        6

4                 3                         7

5                  3                         8

[Anonymous]

What is the logic to add Lock Period in your script??

[stephenedberkg]

i want to calculate the sales amount using lock period only.

for MTD i want to calculate the sales after lock period month.

[Kushal_Chawda]

what is the data & expected output?

[Anonymous]

Thats Fine, You are having ID and MonthID only in your table, and you want to insert Lock Period Flag in the table on what basis or criteria??

[Chanty4u]

is this ur thread?

Re: Set analysis based on lock period

[stephenedberkg]

each id have different lock period

[stephenedberkg]

yeah its my thread suresh

[Anonymous]

Why not create a inline function like this and link it in your data model?

Load * inline

[MonthID, Lock Period

1, 2

2, 2

3,2

4,0

5,0

so on...

];

[stephenedberkg]

month id + lock period

i want to create the flag for  lock period