How to replace first n entries in a column with 0N

Community Support
1

Hi, 

I am running a calculation and I want to replace my first n entries in the row with empty value. How should I do that?

i.e,                  mycol                                     mycol

                --------------------        to              ---------------------

                          a                                              0N

                          b                                              0N

                          c                                               c

                          d                                               d

Thank you so much for your help!

Emily

                -

2

PGRpdiBkaXI9Imx0ciI+dXBkYXRlIG15Y29sOjBOIGZyb20gYG15dGFibGUgd2hlcmUgaSZsdDtu PGRpdj48YnI+PC9kaXY+PGRpdj5BbmRyYXM8L2Rpdj48L2Rpdj48YnI+PGRpdiBjbGFzcz0iZ21h aWxfcXVvdGUiPjxkaXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9hdHRyIj5PbiBUdWUsIEFwciA2 LCAyMDIxIGF0IDI6NTEgUE0gRW1pbHkgV2lsc29uICZsdDs8YSBocmVmPSJtYWlsdG86cHJvanVp eWlAZ21haWwuY29tIj5wcm9qdWl5aUBnbWFpbC5jb208L2E+Jmd0OyB3cm90ZTo8YnI+PC9kaXY+ PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4 IDAuOGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVm dDoxZXgiPkhpLMKgPGRpdj5JIGFtIHJ1bm5pbmcgYSBjYWxjdWxhdGlvbiBhbmQgSSB3YW50IHRv IHJlcGxhY2UgbXkgZmlyc3QgbiBlbnRyaWVzIGluIHRoZSByb3cgd2l0aCBlbXB0eSB2YWx1ZS4g SG93IHNob3VsZCBJIGRvIHRoYXQ/PC9kaXY+PGRpdj5pLmUswqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgbXljb2zCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoG15Y29sPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAtLS0tLS0t LS0tLS0tLS0tLS0tLcKgIMKgIMKgIMKgIHRvwqAgwqAgwqAgwqAgwqAgwqAgwqAgLS0tLS0tLS0t LS0tLS0tLS0tLS0tPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCBhwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgME48L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIGLCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAwTjwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgY8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgYzwvZGl2PjxkaXY+wqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgZMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgZDwvZGl2PjxkaXY+ VGhhbmsgeW91IHNvIG11Y2ggZm9yIHlvdXIgaGVscCE8L2Rpdj48ZGl2PkVtaWx5PC9kaXY+PGRp dj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAtPC9kaXY+DQoNCjxwPjwvcD4NCg0KLS0gPGJyPg0K WW91IHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBiZWNhdXNlIHlvdSBhcmUgc3Vic2NyaWJlZCB0byB0 aGUgR29vZ2xlIEdyb3VwcyAmcXVvdDtLZGIrIFBlcnNvbmFsIERldmVsb3BlcnMmcXVvdDsgZ3Jv dXAuPGJyPg0KVG8gdW5zdWJzY3JpYmUgZnJvbSB0aGlzIGdyb3VwIGFuZCBzdG9wIHJlY2Vpdmlu ZyBlbWFpbHMgZnJvbSBpdCwgc2VuZCBhbiBlbWFpbCB0byA8YSBocmVmPSJtYWlsdG86cGVyc29u YWwta2RicGx1cyt1bnN1YnNjcmliZUBnb29nbGVncm91cHMuY29tIiB0YXJnZXQ9Il9ibGFuayI+ cGVyc29uYWwta2RicGx1cyt1bnN1YnNjcmliZUBnb29nbGVncm91cHMuY29tPC9hPi48YnI+DQpU byB2aWV3IHRoaXMgZGlzY3Vzc2lvbiBvbiB0aGUgd2ViIHZpc2l0IDxhIGhyZWY9Imh0dHBzOi8v Z3JvdXBzLmdvb2dsZS5jb20vZC9tc2dpZC9wZXJzb25hbC1rZGJwbHVzLzdhZGQ0MGI3LTIxOTct NGVmNS04NzljLWNkMWFjOTRkNTNhNG4lNDBnb29nbGVncm91cHMuY29tP3V0bV9tZWRpdW09ZW1h aWwmYW1wO3V0bV9zb3VyY2U9Zm9vdGVyIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9ncm91cHMu Z29vZ2xlLmNvbS9kL21zZ2lkL3BlcnNvbmFsLWtkYnBsdXMvN2FkZDQwYjctMjE5Ny00ZWY1LTg3 OWMtY2QxYWM5NGQ1M2E0biU0MGdvb2dsZWdyb3Vwcy5jb208L2E+Ljxicj4NCjwvYmxvY2txdW90 ZT48L2Rpdj4NCg=

3

if you ever need to replace the first two elements ‘by sym’, for example, depending on ‘i’ won’t help.

one alternative is to explicitly drop the first two elements and append two with null values:

q)t:(mycol:abcd)
q)update (``,2_) mycol from t

careful with this one, because the ‘,’ append operator will be parsed by q-sql if it is not surrounded by parenthesis

another option is to use the ‘@’ amend operator and replace the first two elements with null values

q)update @[;0 1;:;`] mycol from t

4

Thank you so much for your help, Nick!