Need help on data model

[abubakarsiddiq7]

hi

i have the table like below .i need to prepare data model for it can any help me on it.

i have implemented that but i am getting some data mismatch

Note : I need all the coloumns

TableA:

load
Sales Org",
Customer ",
PLQ",
Sold to customer",
Sold To",
Street Name",
city
office
Postal Code
Representative ;

TableB:

LOAD
IKF ,
Sales Org",
Customer ",
PLQ",
Sold to customer
city
office
Store Segmentation
"2019 Sales"

TableC:
IKF,
Sales Org,
Total Accounts

[juliensaintmaxent3113]

hello,

what is the functional link between the table?

in two tables, you have the same field like Sales Org",Customer ",PLQ", is it your functional link?

Bye

[abubakarsiddiq7]

Hi,

TableA: Sales Org",  key field

TableB:  Sales Org" Sold to customer combination of two fields as key field

TableC: IKF, Sales Org, combination of two fields as key field

Thanks

[juliensaintmaxent3113]

If i understand, your link is Sales org, it's the good field which appears in the 3 tables

So rename the other fields from each table to avoid the syn table and keep Sales org

Other solution is to concatenate all table with a add like 'tableA' as TypeFact on the table A, 'TableB' as TypeFAct,...

And in expression, you select what you want with set analysis