Hi team, I have a table and I want if my 'state code' column contains 'R' and 'Number' column contain 11 then 'Type column' should be 'in limit' else Out of limit NumberStates Code Type11R 11R 13o 14o 15o 16R 17R 18C 19J 11R 21C 22J 23R 24C 25J 26R 11C 28J 11R 30C 31J 11R 22C 34J 11R 36C

If it contains and contains

Hi team,

I have a table and I want if my 'state code' column contains 'R' and 'Number' column contain 11 then 'Type column' should be 'in limit' else Out of limit

Number	States Code	Type
11	R
11	R
13	o
14	o
15	o
16	R
17	R
18	C
19	J
11	R
21	C
22	J
23	R
24	C
25	J
26	R
11	C
28	J
11	R
30	C
31	J
11	R
22	C
34	J
11	R
36	C

Datasets

Accepted answers

Qiu

@mmustkee

A select is needed to change the data type for Number column.

0217-mmustkee.yxmd

grazitti_sapna

Hi @mmustkee is this what you are looking for?

I just have one question why is there a need for using contains function when we can specifically mention the number and state code as per the dataset?

Thanks.

mmustkee-Solution-GS.yxmd

All comments

Qiu

@mmustkee

A select is needed to change the data type for Number column.

0217-mmustkee.yxmd

grazitti_sapna

Hi @mmustkee is this what you are looking for?

I just have one question why is there a need for using contains function when we can specifically mention the number and state code as per the dataset?

Thanks.

mmustkee-Solution-GS.yxmd

mmustkee

Hi Sapna,

You are right. NO need to use contains formula. It worked.

Thanks a lot.

Thanks,

Mohammad Mustkeem

mmustkee

Thanks Qiu. You are so quick.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703