Import mapping issue
I have an excel sheet which has to be imported into an module.
It has columns A,B,C,D and from E Column it has Time Dim and each of these have data. PFB the screenshot as below.
In the Module, A Column, B Column, D Column are lists and C Column is just an text filed which has to be imported. Hence I created a line item for C Column. The data 300,400,500 is the data value.
So the module contains Lists(A,B,D Columns), Time Dimension and there are 2 line items called Data which will Import 300,400, 500 and C Column which should Import 'Apple' in the module.
But when I try to create Import action and do the Mapping, I have to put Time Dim as 'Column headers' and 'Ask each time Import is run' for line items(Data, C Column).
If this is done, the line item C Column is not holding the value Apple, Instead it contains 300,400,500.
Please help on the same.