# Field mapping Integer (Index) or Keyword or Word cloud

**URL:** <https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649>\
**Category:** Siren Platform/Investigate Tech Support Community\
**Created:** [September 14, 2023, 4:43pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649 "2023-09-14T16:43:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hud](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/hud/32/297_2.png) [@hud](https://community.siren.io/u/hud)\
**Post date:** [September 14, 2023, 4:43pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649/1 "2023-09-14T16:43:01Z")

</div>

Here’s my column looking like:

Date, Ref\_Nr, Category, Body  
18-Sep-23, 0001-01, Local, “Hello, Bob! Bomb time”

I’d make this fields as: Date, Keyword (for aggregations), Keyword (for aggregations), Text(allow word cloud)

The word cloud for the Body might be nice, but more importantly I can search for e.g. “bomb” in there - would that work? There might be some aggergations done on Category e.g. to count how many percent of the documents are of what category, but should Ref\_Nr be keywords? Or Integer?

---

<div class="post-metadata">

**Author:** ![Davide\_Paoletti](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/davide_paoletti/32/95_2.png) [@Davide\_Paoletti](https://community.siren.io/u/Davide_Paoletti)\
**Post date:** [September 14, 2023, 4:56pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649/2 "2023-09-14T16:56:44Z")

</div>

keyword will allow you to create metrics i.e.: an analytical table with category counts/a pie etc.

---

<div class="post-metadata">

**Author:** ![hud](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/hud/32/297_2.png) [@hud](https://community.siren.io/u/hud)\
**Post date:** [September 14, 2023, 5:10pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649/3 "2023-09-14T17:10:59Z")

</div>

Ah ok. Is there a way to transform 18-Sep-23 into readable 2023-9-18 for Date field?

---

<div class="post-metadata">

**Author:** ![Davide\_Paoletti](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/davide_paoletti/32/95_2.png) [@Davide\_Paoletti](https://community.siren.io/u/Davide_Paoletti)\
**Post date:** [September 14, 2023, 5:29pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649/4 "2023-09-14T17:29:43Z")

</div>

Assuming you already mapped as date in any ES compatible format, in the entity table settings/field tab, unlock the changes and click on the format link (default in the screenshot):

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/515836e10045e53435ce59465f02480f347ac3fe.png)  
You can change it to any readable format you like.

---

<div class="post-metadata">

**Author:** ![hud](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/hud/32/297_2.png) [@hud](https://community.siren.io/u/hud)\
**Post date:** [September 14, 2023, 5:52pm UTC](https://community.siren.io/t/field-mapping-integer-index-or-keyword-or-word-cloud/649/5 "2023-09-14T17:52:24Z")

</div>

Okay thank you!

Finally, when I ingested I used the Siren NLP plugin and I see it works e.g. it creates columns `siren.nlp.ids.entity/person` with correctly identified persons. I wanted to put in the dashboard the body along with these identified words e.g. `siren.nlp.taxonomy_annotated.body and` as one of the columns, but these do not show - how to show those words highlighted?

@Davide_Paoletti wondering if the record table / NLP annotation is available for the community edition?