# Setting up Field Mapping

**URL:** <https://community.amazonquick.com/t/setting-up-field-mapping/51322>\
**Category:** Q&A\
**Tags:** dataset, Business-Intelligence-Engineer\
**Created:** [January 28, 2026, 6:47pm UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322 "2026-01-28T18:47:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![TraderRef](https://avatars.discourse-cdn.com/v4/letter/t/ce7236/32.png) [@TraderRef](https://community.amazonquick.com/u/TraderRef)\
**Post date:** [January 28, 2026, 6:47pm UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322/1 "2026-01-28T18:47:19Z")

</div>

I have fields in a SPICE dataset that have different names in the Direct Query dataset used to report transactions. An example of this is Patient ID in the SPICE dataset and Cardholder ID in the DQ dataset. If a dashboard consumer clicks a particular patient ID in a top 10 bar chart which uses the SPICE dataset, I need a table that uses the DQ dataset to filter on the transactions for that Patient ID, but Cardholder ID is the column for that in the DQ dataset. How can I get them to map as I do not see any options within the Analysis to do this? It only shows the fields which are already mapped.

---

<div class="post-metadata">

**Author:** ![Adedolapo](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Adedolapo](https://community.amazonquick.com/u/Adedolapo)\
**Post date:** [January 29, 2026, 3:23pm UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322/2 "2026-01-29T15:23:41Z")

</div>

Hello TraderRef,

I am currently investigating this and will revert.

Regards,

---

<div class="post-metadata">

**Author:** ![Adedolapo](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Adedolapo](https://community.amazonquick.com/u/Adedolapo)\
**Post date:** [January 29, 2026, 5:25pm UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322/3 "2026-01-29T17:25:06Z")

</div>

Hello TraderRef,

To get the fields to map properly, follow instructions in below doc. Section Mapping fields:

[https://docs.aws.amazon.com/quicksuite/latest/userguide/mapping-and-joining-fields.html](https://docs.aws.amazon.com/quicksuite/latest/userguide/mapping-and-joining-fields.html)

As an alternative, I’d like to direct you to our detailed solution in the AWS Big Data Blog, specifically focusing on Use Case 2: filtering across multiple datasets.

> **[Using QuickSight parameters and controls to drive interactivity in your...](https://aws.amazon.com/blogs/big-data/using-quicksight-parameters-and-controls-to-drive-interactivity-in-your-dashboards/)**
>
> Amazon QuickSight added support for parameters, on-screen controls, and URL actions earlier this year. In this blog post, we walk through several examples to show how you can use these capabilities within interactive dashboards for your audience.

This guide provides step-by-step instructions on:  
• Setting up parameters for cross-dataset filtering  
• Implementing control elements  
• Configuring filter interactions between visuals

Regards,

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [February 15, 2026, 6:56am UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322/4 "2026-02-15T06:56:17Z")

</div>

Hi @TraderRef

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![TraderRef](https://avatars.discourse-cdn.com/v4/letter/t/ce7236/32.png) [@TraderRef](https://community.amazonquick.com/u/TraderRef)\
**Post date:** [February 17, 2026, 6:02pm UTC](https://community.amazonquick.com/t/setting-up-field-mapping/51322/5 "2026-02-17T18:02:30Z")

</div>

I had to open a support case and showed them the behavior and they agreed that something is not working correctly. They escalated and got someone else involved who observed it, as well, and are still working with me on it.