Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We were having the sales data for different stores and each store is categorise into 2 types one is App initiated and App not-initiated.
Here i want to create buttons for initiated stores.
In the below stores only the stores 83,84,86,34,118,2,12 were App initiated stores .
Here i need to create two buttons or listbox so that if i select App Initiated it will shows the initiated stores and same for App not-initiated stores.
Stores:
123 |
128 |
45 |
66 |
48 |
47 |
43 |
42 |
41 |
106 |
94 |
87 |
81 |
89 |
97 |
107 |
92 |
110 |
88 |
121 |
83 |
84 |
86 |
34 |
118 |
2 |
12 |
14 |
5 |
77 |
73 |
16 |
Thanks..
You could create an additionally categorizing field for this, for example:
if(match(Stores, 83,84,86,34,118,2,12), 'App initiated', 'not App initiated') as StoreCluster
- Marcus
if you have the details for App initiated stores and App not-initiated stores then I would suggest you to create a flag for the same in the script and use it in the front end .
how you will identified the App initiated stores and App not-initiated stores ?
Hi,
PFA for sample data.
We have data for App initiated only from that need to differentiated.
Thanks..
I would see the sheet name Initiated but could not find the store_id, if you know the exact sheet name and column then try like this
LOAD Store_ID
from
Initiated sheet ;
Store_Information:
LOAD *,
if(exist(Store_ID,Store_Id),'App initiated', 'not App initiated') as Store_info
Thanks! Marcus it's working but i need this dynamically, so that every time no need to do it manually.
@ Avinash
Can you please check once the logic you provided.Below is the result am getting when i put it in Edit Script.
Thanks..
In the Initiated sheet which is the store_Id field ??? is the Location is store_id ??? could you please confirm this info
Yeah i have renamed Location into store_id in the Initiated sheet and then i have use the logic.
Thanks..
Ok then don't rename the Location field and try like this
LOAD Location as LC
from
Initiated sheet ;
Store_Information:
LOAD *,
if(exist(LC,Store_Id),'App initiated', 'not App initiated') as Store_info
you should retain the order of load
Quite common for such tasks is the use of Mapping … and not the geographical kind. But like you see (with match or exists) there are also others ways possible.
- Marcus