Need to get Count of Fact table in one column and count from 4tables in one column

[MS90]

 

Need to get Count of Fact table  in one column and count from  4tables in one column.

Applied concatenate on four tables but count is getting error and applied link table on Name column of four tables getting data but not showing data dynamically when applied link table on key column of four tables getting incorrect data.

Please find attached sample data.

[BrunPierre · Accepted solution]

[Fact Table]:
LOAD *,
Barcode as FT_Barcode
Inline [
Barcode,Name,Dealer
1,Gold,x
2,Gold,Y
3,Silver,z
4,Silver,v
8,Diamond,h
9,Diamond,i
10,Platinum,k
11,Platinum,l ];

[Table ABCD]:
//[Table A]:
LOAD * Inline [
Barcode,Name,Manufacturing Plant
1,Gold,California
2,Gold,California
];

Concatenate([Table ABCD])
[Table B]:
LOAD * Inline [
Barcode,Name,Model
3,Silver,asd
4,Silver,dff
5,Silver,gfhh
];

Concatenate([Table ABCD])
[Table C]:
LOAD * Inline [
Barcode,Name,Shipping
6,Diamond,Canada
7,Diamond,Dubai
8,Diamond,Aus
9,Diamond,UK];

Concatenate([Table ABCD])
[Table D]:
LOAD * Inline [
Barcode,Name,Quantity
10,Platinum,23
11,Platinum,54
];

Concatenate([Fact Table])
LOAD Barcode as ABCD_BarCode,
*
Resident [Table ABCD];

DROP Table [Table ABCD];

[MS90]

Thank you for replying

But in my case column A i.e, key field(Barcode) and column C in all 5tables  there more than 1million records but column b i.e,  field (Name) there are only 4 values i.e,(gold, diamond, silver, platinum)

[BrunPierre]

The actual tables should be used in place of the inline loads.