Changing Data Source When Column Headers Are Different

[shayank]

Hi,

I have created a dashboard which shows us the monthly sales. For example for the month of July, column headers will be Sales July 2021, COGS July 2021, Sales Forcast July 2021 e.t.c. So when I try to change data source so that I can import the data for the month of August, I get the error,

The column headers for the August data will be Sales August 2021, COGS August 2021, Sales Forcast August 2021 e.t.c. The monthly data files are in Excel.

I would manually change the column headers but I have 62 column headers that I will need to change on a monthly basis which is time consuming. Is there a workaround to this or an easier way or am I doing something wrong?

[shayank]

Hi Phil,

I am using the Excel Workbook connector to load the data currently.

[PhilipTreacy · Accepted solution]

Hi @shayank 

Really your data should have columsn called Sales, COGS, Forecast and Date, then new data can be easily loaded and appended to any existing data.

How are you loading the data currently?  Using the Folder connector or using the Excel Workbook connector?

Regards

Phil