# Visualize customerId mapped to customer name in e.g. Kibana table
**URL:** https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390
**Category:** Kibana
**Created:** [January 4, 2024, 2:03pm UTC](https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390 "2024-01-04T14:03:42Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@rickardo](https://discuss.elastic.co/u/rickardo)
#### Post date: [January 4, 2024, 2:03pm UTC](https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390/1 "2024-01-04T14:03:42Z")
We have reports entries like below and Visualize statistics from "reports" in a Kibana table.
But to show customerId=1 makes no sense so want to show them by their name that are defined in another Index in this case.
Looking around and can't seem to find anything useful, closest i found was "static lookup" but that seem to be deprecated in latest versions and there you would have to manually enter key/values.
Index: reports
{"customerId" : 1,"type" : "view","country" : "FI"}
{"customerId" : 1,"type" : "click","country" : "FI"}
{"customerId" : 2,"type" : "view","country" : "DE"}
{"customerId" : 3,"type" : "view","country" : "DE"}
Index: customers
{"Id" : 1,"name" : "Customer\_1"}
{"Id" : 2,"name" : "Customer\_2"}
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [January 4, 2024, 10:25pm UTC](https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390/2 "2024-01-04T22:25:04Z")
The best option is probably to use an enrich policy: [Enrich your data | Elasticsearch Guide [8.11] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/ingest-enriching-data.html)
You can configure these in Stack Management → Index Management → Enrich Policies.
---
### Author:  [@rickardo](https://discuss.elastic.co/u/rickardo)
#### Post date: [January 5, 2024, 9:43am UTC](https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390/3 "2024-01-05T09:43:30Z")
Thanks for you answer!
I undertand if there is no other way though I think it is really bad data management to have to enrich data in that way (if I understand it correctlly). So change of name would lead to have to update all documents in the index.
Much of the idea of having a seperate id and name is gone.
Actually i can't believe it is not supported, seems such a basic thing to have. Alreadu encountered this is several projects.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 2, 2024, 9:43am UTC](https://discuss.elastic.co/t/visualize-customerid-mapped-to-customer-name-in-e-g-kibana-table/350390/4 "2024-02-02T09:43:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.