Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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