Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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