# Unable to update field mapping

**URL:** <https://community.amazonquick.com/t/unable-to-update-field-mapping/33731>\
**Category:** Q&A\
**Tags:** data-source, filters, dataset, Business-Intelligence-Engineer, quick-sight\
**Created:** [August 12, 2024, 3:47pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731 "2024-08-12T15:47:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![prestonb](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@prestonb](https://community.amazonquick.com/u/prestonb)\
**Post date:** [August 12, 2024, 3:47pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/1 "2024-08-12T15:47:22Z")

</div>

Hi all,

I just uploaded a new dataset to an existing analysis, and I am unable to get one of my fields to map. All fields except for the “Project type” field are correctly mapped and are filtering just fine.

I originally made the mistake of titling the column “Project Type” (capitalizing the word ‘type’), so Quicksight was unable to map the field correctly. I then tried creating a calculated field called “Project type” (the word ‘type’ correctly not capitalized), but the mapping did not update. I then created a new, identical column in my new dataset with the correct title and it still is not mapping.

What can I do to make this work?

---

<div class="post-metadata">

**Author:** ![Wakana](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wakana/32/3520_2.png) [@Wakana](https://community.amazonquick.com/u/Wakana)\
**Post date:** [August 13, 2024, 1:43am UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/2 "2024-08-13T01:43:21Z")

</div>

hi @prestonb

Welcome to Quick Sight Community and thank you for posting a question.

I am guessing you are trying to have cross dataset filtering. Cross dataset filtering should work even if all the fields in target dataset don’t have a match. What matters is whether the fields being used for filtering are present in target dataset and correctly picked as a match in the field mapping.  
Are you trying to create a filter on Project type column?

kind regards,  
Wakana

---

<div class="post-metadata">

**Author:** ![prestonb](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@prestonb](https://community.amazonquick.com/u/prestonb)\
**Post date:** [August 13, 2024, 3:41pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/3 "2024-08-13T15:41:26Z")

</div>

Hi Wakana, that is correct: I’m trying to create a cross-dataset filter on the Project type column. You mentioned that it’s important to correctly pick the field as a match in the field mapping – can I do that myself? I’m only aware of the automatic mapping, which hasn’t been working.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 16, 2024, 5:59pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/4 "2024-09-16T17:59:42Z")

</div>

Hi @prestonb,  
It’s been awhile since there’s been any activity on this topic; were you able to find a work around solution for your case or are you still in need of further assistance?

Here’s some additional documentation about [mapping and joining fields](https://docs.aws.amazon.com/quicksight/latest/user/mapping-and-joining-fields.html).

Let us know if you have any additional questions; if we do not hear back within 3 business days, I’ll go ahead and close out this topic!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 23, 2024, 9:30pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/5 "2024-09-23T21:30:18Z")

</div>

Hi @prestonb,  
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 23, 2024, 9:30pm UTC](https://community.amazonquick.com/t/unable-to-update-field-mapping/33731/6 "2024-09-23T21:30:21Z")

</div>


