When Append file i get error msg on BRAND_F already used ?

[admin11]

Hi All

I have 2 Table :-

SALES_I

SALES_T

I like to Append these to Table the above 2 Table into final Table = SALES

When i start to append , i get error msg .

My question is Why my 2 table unable to have BRAND_F , since it is column. 

Hope some one can advise ?

Below link is my PBI file :-

https://www.dropbox.com/s/u0uzz400rkwoww8/PBTI_V032%20ask%20APPEND.pbix?dl=0

Remark :-

If i rename BRAND_F to BRAND_F1 , the next error msg , SBU field name already used in table , i need to rename SBU to SBU1 , then next error will appear.

Paul 

[admin11 · Accepted solution]

Hi All

I have change the Append from SALES_T and Append to SALES_I , now no issue. 

Paul