I have a table called 'listingsTable. It displays data from a query called getListingsTable. This table appears when I have double clicked on a customer row in a table called customerTable.
customerTable contains a field called CUSTOMER_ID
listingsTable contains a field called PRODUCT_ID
I have another query called getCustomerSales, with a field called SALES for combinations of CUSTOMER_ID and PRODUCT_ID
Is there a way (other than a JOIN via SQL), that would let me create a custom column in 'listingsTable' and map each row to a corresponding value in my getCustomerSales query?
...almost like a VLOOKUP where the {{customerTable.selectedRow.CUSTOMER_ID}} and {{listingsTable.currentRow.PRODUCT_ID}} matches a combination from the getCustomerSales query and displays the corresponding SALES value?
This should be doable if you have both product_id and customer_id in the same row. You could create a custom column and in the mapped value use a find, e.g
You're getCustomersales.data is formatted as an array,
There are matches for all combinations (otherwise the find function will return an error, and you will have to account for that scenario in the function)
You should be getting the result you want.
I hope I understood this correctly and that this guides you towards a solution!
