lokup table show repeated value for a filed
# gooddata-cloud
k
lokup table show repeated value for a filed
k
Thinking completed Repeated Values in a Lookup Table Repeated (duplicate) values in a lookup/visualization table in GoodData are typically caused by one of the following: 1. Non-Unique Attribute Used for Joining or Filtering If you use a non-unique field (e.g., a name or label) as a join key or filter, GoodData treats each occurrence as a separate entity, resulting in duplicated rows. Recommended fix: Always use a unique identifier (primary key/ID column) for joins and filters. You can still display a readable label (like a name) in the UI while the underlying logic uses the unique ID. [Attribute Filter Docs] 2. Many-to-Many (M:N) Relationships — Double Counting If your data model has a many-to-many relationship between datasets, slicing a metric by attributes from both sides of the relationship causes values to repeat for each matching row on the other side. [Many-to-Many in LDM] gooddata.ai/docs/ad/mton03.webp Recommended fix: Use the allocation factor technique to handle M:N relationships correctly. 3. Grain / Fan-Out Join Multiplier If a fact table is joined across a 1:N or M:N relationship, a single fact value gets summed repeatedly for each matching row in the joined table. This can cause dramatically inflated numbers. Recommended checks: • Remove attributes from other fact/detail tables in the visualization to see if inflation disappears. • Inspect the generated SQL by changing
/edit
to
/debug
in the Analyze tab URL to download the
explainAfm.zip
archive with the generated query. • Ensure the dataset's primary key/grain is properly defined and relationships are 1:N, not causing circular or M:N fan-outs. 4. Secondary Label with Duplicate Values in Filters GoodData's improved attribute filters now use the primary unique label in the backend and display the secondary label in the UI. If multiple records share the same secondary label (display text) but have different primary keys, they will appear as separate entries in the filter. [Object Labels and Filters] If you want to display them merged, you can use the
enableDuplicatedLabelValuesInAttributeFilter
prop in the GoodData UI SDK:
Copy code
<AttributeFilter
    filter={newPositiveAttributeFilter(Md.UserId.Default, ["10006"])}
    onApply={this.onApply}
    enableDuplicatedLabelValuesInAttributeFilter={true}
    displayAsLabel={Md.UserId.UserName.attribute.displayForm}
/>
[Attribute Filter Docs] To narrow down your specific case, could you share more details in this thread — such as the field that is repeating, how your datasets are related in the LDM, and whether the repeated values appear in a visualization or a filter? The Support team monitors this thread and will step in if further investigation is needed. image 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.
s
Hi Krishti. Please try to check the items mentioned by our GoodData Support AI. Feel free to ask it directly here in the thread (@kapa.ai) if you have any further questions. We are here and ready to step in if there are more complex questions.
k
Thinking completed Thank you for the message! It looks like this is directed at another person in your team rather than a question for me. If Krishti (or anyone else in the thread) has follow-up questions about the duplicate values issue — such as how to inspect the LDM, check the generated SQL, or configure attribute filters — feel free to ask here and I'll be happy to help. The GoodData Support team is also monitoring this thread and will step in if needed. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.