Importing extra column in dimension table | Excel forum

Hi Jens,

I have a dimension table called majorbudgets. It's purpose is to analyse across all budgets, but grouping the smaller/insignificant budgets as 'OTHERS'.

If I refresh the table it ignores the new column.
If I import it, I get an additional table named majorbudgets1, but it does include the new column.

I could delete the old table and add the new 'majorbudgets1' and reconnect the relationships, but this seems a rather long winded process for the simple addition of a column.

How do I import/refresh the amended table so that the extra column is included in my data-model?

CEMAS Business Information Officer
British Red Cross