I have a requirement to cap the values >=vmin and<=vmax, so in case it is just the capping of a number greater than vmax i would use ragemax or ragemin as expected but here i need to do it both the ways.
For eg:
My dataset is as below:
Dim
Val
A
10
B
54
C
32
D
85
E
12
F
65
and I want to create a table with expected col like below:
Dim
Val
Expected
A
10
20
B
54
50
C
32
32
D
85
50
E
12
20
F
65
50
where vmin=20 and vmax=50
Could anyone please help me on the same.
Values of vmin and vmax are dynamic and shall change based on user input
