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?