Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi People!
Please Help me, I try to make a consecutive number like this:
COD NIT Consecutive
00000 123456 000001
00000 123456 000001
00000 123456 000001
00000 123456 000001
00000 234567 000002
00000 234567 000002
00000 234567 000002
00000 234567 000002
00009 345678 000003
00009 345678 000003
00010 345678 000003
00010 345678 000003
00011 345678 000003
I need to assign the consecutive number and this depends on NIT and COD value.
Check this script
Table:
LOAD RowNo() as RowNum,
*,
Num(AutoNumber([NIT&COD1], Left([NIT&COD1], 7)), '000000') as CONSEC;
LOAD * INLINE [
NIT&COD1
500096929000000
500096929000000
500096929000000
500096929000001
500096929000001
500096929000001
500096929000002
500096929000002
500096929000002
500096929000009
500096929000009
500096929000009
500122959000955
500122959000955
500122959000955
500129157000959
500129157000959
500129157000959
500129157000960
500129157000960
500129157000960
500150250000012
500150250000012
500150250000012
];
It seems to be only dependent on NIT... May be this
Num(AutoNumber(NIT), '000000') as Consecutive
I would say
Hash128(COD,NIT) as Consecutive,
as I see it's only based on NIT no?
and do u want it on the script or in a table? without altering the script?
My calculation conditions changes. Now I need to make this:
COD NIT&COD1 CONSEC
00009 123450001 000001
00009 123450001 000002
00009 123450001 000003
00009 123450002 000001
00009 123450002 000002
00009 123450003 000001
00009 123450004 000002
00010 456780001 000001
00010 456780002 000001
00010 456780002 000002
How I can enumerate in this form?
I need to do that in the script
This
Num(AutoNumber(RowNo(), COD&NIT&COD1), '000000') as CONSEC
NIT&COD1 CONSEC
500096929000000 | 00001 |
500096929000000 | 00001 |
500096929000000 | 00001 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500150250000012 | 00001 |
500150250000012 | 00001 |
500150250000012 | 00001 |
500150250000012 | 00001 |
500150250000012 | 00001 |
And, have you any idea for this format?
Not sure I understand the question? Can you elaborate?
In this case I need a consecutive code that correspond with NIT&COD1 but when NIT&COD1 changue, the consecutive start in 00001 again. This data is in groups.
NIT( first 9 characters); COD1(next 6 characters); COD1 define a new group on master group defined by NIT. When NIT changues The consecutive should start in 00001 again.
NIT&COD1 CONSEC
500096929000000 | 00001 |
500096929000000 | 00001 |
500096929000000 | 00001 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000001 | 00002 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000002 | 00003 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500096929000009 | 00004 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500122959000955 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000959 | 00001 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500129157000960 | 00002 |
500150250000012 | 00001 |
500150250000012 | 00001 |
500150250000012 | 00001 |