Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NashaYussof
Partner - Contributor II
Partner - Contributor II

Binning ID uniqueness for each SSE GeoOperation Binning

Hi everyone.

I need to ask:

Due to limitation of Geo-Operation in its website, I need to make my binning processes in batches (as per suggestion when I read through community post related to GeoOperation).

 

I wonder for the binning ID generated, will there be any possibilities it will be different for each batch? 

For example, for batch 1 of SSE, ClientID A(x,y) will have binID(01). But in batch 2 of SSE, ClientID B with similar (x,y) as A going to have binID(02) instead.

 

The reason for this question is because I'm need to generate 2 tables in my ETL app:

1 table consist of ClientID, coordinate and Binning ID

1 table consist of Binning ID

Later I need to link them in my dashboard app by using Binning ID as key.

NashaYussof_0-1624830798692.png

 

 

Labels (2)
1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

Should work without really knowing, it's possible to modify the result in load statement

Load f.GCC_NAME16 & 'some string' as f.GCC_NAME16

Or modify the resulting table by doing a resident load

left join(bin)

load bin_id, '1234' as extrakey resident bin;

Thanks,

Patric

View solution in original post

1 Reply
Patric_Nordstrom
Employee
Employee

Should work without really knowing, it's possible to modify the result in load statement

Load f.GCC_NAME16 & 'some string' as f.GCC_NAME16

Or modify the resulting table by doing a resident load

left join(bin)

load bin_id, '1234' as extrakey resident bin;

Thanks,

Patric