Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have data like this
t1:
load * inline [
date,id,sales
1/1/204,_03_01,100
1/2/204,_03_02,200
1/3/204,_03_03,300
1/4/204,_03_04,400
1/5/204,_03_05,500
1/6/204,_03_06,600
1/7/204,_03_07,700
];
t2:
load
autonumberhash128(date,id,sales) as new,
autonumberhash128(date,id) as new1,
resident t1;
drop table t1;
when i reload this script i am getting data for 'new' and 'new1' fields like
new:
1
3
5
7
11 and for
new1:
2
4
6
8
how i am getting odd values for one field and even values for other field , what is reason behind this
i know that autonumber hash creates a unique integer value
Dear Commonqlik,
You are right, field "new" is showing odd numbers and field "news" is showing even numbers.
It's happening due to the same autonumberhash128, when first line execute it generate "1" for field "new" and when it moves to the next line it finds the same autonumberhash128, then it generate "2" for field "new1" and same for each step.
Kindly find attached document.
Kind regards,
Ishfaque Ahmed
Dear Commonqlik,
You are right, field "new" is showing odd numbers and field "news" is showing even numbers.
It's happening due to the same autonumberhash128, when first line execute it generate "1" for field "new" and when it moves to the next line it finds the same autonumberhash128, then it generate "2" for field "new1" and same for each step.
Kindly find attached document.
Kind regards,
Ishfaque Ahmed