Forum Discussion

alinamarinbadea's avatar
alinamarinbadea
Frequent Visitor
1 year ago

Cross-check two tables

Hello! I have a bit of a complicated task.  We have a list of spare parts, each with one or more variants. Each Variant is compatible with a certan Product. Compatibility is either tested (Yes) or i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from Kedar_Pande.

 

Hi alinamarinbadea ,

 

Based on the description of your problem, I reproduced your question and made some changes, hopefully this will fulfill your needs.Here are the exact steps:

 

1.Create relationships:

 

2.Create two new columns in the Compatibility table:

Part = RELATED('Parts with variants'[Part])
UpdatedTBD = 
IF (
    CONTAINSSTRING (
        CONCATENATEX (
            FILTER ( 'Compatibility', 'Compatibility'[Part] = EARLIER ( 'Compatibility'[Part] ) ),
            'Compatibility'[Compatible],
            ","
        ),
        'Compatibility'[TBD]
    ),
    BLANK(),
    'Compatibility'[TBD]
)

 

3.Replace 'Compatibility'[variant] with 'Compatibility'[Part] and replace 'Compatibility'[TBD] with 

'Compatibility'[UpdatedTBD]:

 

4.The final result is as follows:

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

alinamarinbadea's avatar
alinamarinbadea
Frequent Visitor
1 year ago

Thank you, Anonymous , it worked. However, I have two additional questions:

1. Is there any way to sort this column to say A; B; C; E on the first row instead than A; E; B; C ?

2. How would I adapt the formula if the relationship between tables is many to many (one variant can go in multiple parts)

  • alinamarinbadea's avatar
    alinamarinbadea
    Frequent Visitor
    1 year ago

    Can anyone assist here please?