Mapping timescale during import and ignoring some columns
I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time.
Attaching screen shots for your reference.
In the source file attached , the first column simply maps to the list whereas the next five columns needs to be imported into a different destination and can't be get rid of. After these five columns I need the data to be imported for respective time periods.
When I map the Time to Column headers, I get an error because of these five columns.
I can't remove these columns from the source file,neither can I map them to a list.
Can anyone provide me any solution on how do I get rid of the error. We can change the source file format if necessary but cannot ask the user to upload separate files.
Any help would be appreciated