This content has been marked as final. Show 3 replies
I have an Excel data source that looks like follows:
|Egypt, Arab Rep.||7.1%||7.2%||4.7%|
I need to create a column called 'Year' so that I can use this field as a filter and dimension.
I would like my table to be loaded in as follows:
|Egypt, Arab Rep.||2007||7.1%|
|Egypt, Arab Rep.||2008||7.2%|
|Egypt, Arab Rep.||2009||4.7%|
Without changing the data source, is there a way to achieve this in the load script?