Issue while loading from Excel File...?

[vishalgoud]

Hi Experts,

I have an Excel File Which Contains  Different categorizes in one sheet  for the year 2015 and Each category is different from other.

categories cells are in BOLD format...

attaching the Jan sample data below , PFA ..Attached data is just for January month we have Complete year data..

Each category is having different data ( different rows )..

now i want to load all the categories data and if i select year 2015 it has to display all the categories , and if i select any category it has to show all the its related values...

here the problem is all the categories are present in only one sheet..while loading the data we are getting different fields which are not Expected...

tried with cross table method but no result, any other method to load these different categories in one table..

or whether we need to change the Excel format...?

Please find the below excel sheet and let me know your possible solutions on this..

Thanks in Advance...

Best Regards

Vishal

[jsingh71]

Hi Vishal,

Can you please upload a sample excel sheet.

[MK_QSL]

Can you provide some sample data in excel file please?

[jonathandienst]

vishal goud wrote:

now i want to load each category as a separate table

May I ask you why you want load these in separate tables? This will result in a data model that if difficult to report from and may give incorrect results due to the synthetic keys that will be produced. This is not an optimal model design from QV and it may be possible to deliver what you need without such an awkward data model.

[vishalgoud]

Please find the Attached sample file which contains 6 categories (dark cells),

I want to load Category wise data and  data should be separate for Each category , I don't want to load each category as Separate Table as it Create Synthetic Keys...

Thanks in Advance..

Regards

Vishal.

[vishalgoud]

Hi Jonathan,

Thank very much for your  suggestion. please find the Above attachment and try to provide the alternate solution for this issue.

Regards

Vishal..