Hi all So my data se has a column name as CODE and these are integers in nature. Just like below
What i need is to Filter on code column where SCC => 900 (exclusive of 901, 902, 903, 915, 920, 921, 925, 929, 931, 932 and 933); update the CATEGORY column for these rows to reflect ‘SCC 900 Range’.
CODE
900
901
902
903
904
905
906
920
921
can some one help me achieve this
@Sameer_Kanade8810 |
if [CODE] >=900 and [CODE] not in (901, 902, 903, 915, 920, 921, 925, 929, 931, 932, 933) then "SCC 900 Range" else [CODE] endif
please find the formula attached
mark done if solved.
@Sameer_Kanade8810 - see solution attached
@Sameer_Kanade8810
workflow attached for reference.
@Sameer_Kanade8810
is this solved.