Forum Discussion
Alias table creates duplicate columns
I have a Dataset with the following relation.
TableA- TableB-TableC-TableA1
I am noticing that certain columns in TABLEA & TABLEA1 have been duplicated.
Is this by design & if so why only certain columns have been duplicted?
Should I delete these columns from the Model?
6 Replies
Anonymous provide more details. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490TableA & TableA1 are the same table. The table has around 50 columns.
By requirement we had to alias this. The Dataset has a select * from TableA where TABLEA.COLUMN5 ='xyz' as the query.
Do not understand why certain columns have been duplicated all of a sudden. These duplicates were not present when we deployed the model.
One difference I noticed is that CREATEDBY column in the Table populated new user values over the last run instead of our standard SSIS user.
Anonymous I'm not sure what you mean by duplicate columns, please explain in detail.
