Loading Data into QV application

[sindhura]

I have three different Excel sheets of data in which they are of the form

1. births per 1000 population per Country and per year from 1800 to 2099.

2. Population growth(annual %) per Country and per year from 1800 to 2099.

3.Total population per Country and per year from 1800 to 2099.

When I am trying to load the data,  the script execution process seems struck with elapsed time being still and close button is not enabled. I guess because all the Field names are same, syn keys are forming.

Can anyone please help me out how can I load this type of data and make analysis out of it.

[oknotsen]

Make sure all the field names are unique with the exception of the key field(s ). Preferably have a relation based on 1 (key) field. But even if more fields combined are the key, giving everything else a unique name should solve your problem.

[Anonymous]

You could concatenate the data from the 3 sheets into a single QlikView table.

[jagan]

Hi,

Try like this

Data:

LOAD

*,

'Birth' AS DataType

FROM Births;

Concatenate(Data)

LOAD

*,

'PopulationGrowth' AS DataType

FROM PopulationGrowth;

Concatenate(Data)

LOAD

*,

'TotalPopulation' AS DataType

FROM TotalPopulation;

Now using this flag you can filter the data in expressions using Set analysis.

Hope this helps you.

Regards,

Jagan.

[oknotsen]

Since it is not the same data and he does not mention any (other) tables to be used as Dimensions, that would not be my first suggestion. But yeah, you could of course.

[Mark_Little]

Hi,

If you are unsure, one thing i would advise is from the script editor, choose the debug option and tick the limited load.

Just load 10 lines, then check the data model.

From there you can see what is return, then see if you need to concatenate or rename fields.

Mark