Hello, first post here 🙂
I have two tables:
1. TABLE A where I have the folllowing columns (among others)
> "PART ID" > Duplicated values
> "SUPPLIER ID" > Duplicated values, no only for same PART ID but also can have same supplier ID for different Part IDs
> "SUPPLIER STATUS" > Where I can have as one of the possible status "Recommended"
| RFPCode | SupplierIDNumber | SupplierRFPStatus |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 31 | 72 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 491 | 70 | Recommended |
| 492 | 70 | Recommended |
| 492 | 70 | Recommended |
2. TABLE B where I have the following columns (among others)
> "PART ID" > Unique values, already related to TABLE B, relationship active, many (Table B) to one (Table A).
> I want to create a new column that brings only ID from suppliers that have a recommended status.
- I already tried with related function but is not working, I understand because relationship is many to one.
- If I do the connection in the graphic directly, it duplicates all the IDs for x times as it appears in Table A
- I thought of creating a new table using FILTER to bring only unique values for RFP CODE and SUPPLIER ID when Status is equal to "Recommended"? and then connecting to the table b? However I have only gone this far:
TABLE C = filter(TABLEA,
TABLEA[SupplierStatus]="recommended")
And I get a new table with only the data containing the ID of the Suppliers that are recommended, But I still get more than one line per PART ID and do not know how to filter per unique values in column "PART ID"
Thanks!
