Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the logic to add Lock Period in your script??
i want to calculate the sales amount using lock period only.
for MTD i want to calculate the sales after lock period month.
what is the data & expected output?
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??
is this ur thread?
each id have different lock period
yeah its my thread suresh
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...
];
month id + lock period
i want to create the flag for lock period