Loading Data to Load Editor

[nickmarlborough]

Hi, 

I am trying to re-model my data creating a new dashboard using Qlik. 

I have a master sheet if you will containing field names and one of the field names being an ID that in turn will be used to connect other data sets. 

That being said, to avoid confusion in the dashboard and data load editor, i only want to have one association (that being the ID) and no other.

The data sets that i am loading are large but often contain overlapping fields containing the same field names to other data sets. I am aware that if they are loaded - more associations would pop up which is not ideal. 

Is there a way when loading the data (Excel) to essentially not load fields if they already feature in the load editor somewhere?

Thank you!

[RamanaKumarChintalapati]

Hi @nickmarlborough ,

Using Qualify and unqualify statements in the Load editor can avoid another associations other than required association.

Here is the example:

QUALIFY *;

UNQUALIFY OrderID;

Orders:    

     LOAD OrderID,

               OrderName,

               CustomerName,

     FROM xxx.xls;

UNQUALIFY *;

This will result in a table with fields like this:

     OrderID

     Orders.OrderName

     Orders.CustomerName

Another approach while loading data from excel to Qlik Sense  by using File & Other Sources , it will not associate the fields automatically table name will add as prefix to field name when the data profiling is enabled

Hope it works for you!!!

Thanks!!!

[anat]

as @RamanaKumarChintalapati  said use Qualify / Unqualify to avoid more association (synthatic keys)

or else you can rename the fields based on requirement.

[nickmarlborough]

by using qualify and unqualify, will i not make it so the tables cannot be associated based on the ID i wanted originally?

for example....

[Table 1]:

LOAD

ID

Name

Location 

[Table 2]

ID

Family Name

House Address

if i said UNQUALIFY you would get Table1.ID and then Table 2.ID and they would not be able to be assoociated. Is there a way to do what you said and unqualify but still link on the ID?

[F_B]

No, it's the opposite.

You qualify all the fields of [Table 1] and [Table 2] so they get the prefix, and you unqualify the field ID, so it doesn't.

Here is a better explanation than mine: Qualify | Qlik Sense on Windows Help

Hope this can be helpful

[nickmarlborough]

hmmm very odd. 

I have done as follows:

Qualify*;

Load [ID] from Table 1

Load [ID] from Table 2

UnQualify*;

Name

Location

From Table 1

UnQualify*;

Name 

House Address

From Table 2

but i still get a synthetic key..... (it is worth noting, Table 1 and Table 2 join of some of the IDs but not all, i.e. there may be some ID in Table 1 and not table 2 and vice versa)

Thanks for your help!

[F_B]

Qualify*;

UnQualify ID;

LOAD Name,

LOAD Location,

From Table 1

Qualify*;

UnQualify ID;

LOAD Name ,

LOAD House Address,

From Table 2

[nickmarlborough]

this doesnt seem to work as there is no load for the ID....

[F_B]

My apologies for the mistakes in my previous answer.

Table_1:

QUALIFY *; //activating qualify will add Table_1. as prefix before the field names in the following load

UNQUALIFY ID; //this excludes the field ID, so it doesn't get the prefix and becomes your key

LOAD

ID,

Name,

Location 

FROM YourDataSourceForTable_1;

UNQUALIFY*; //this stops the previous activation of QUALIFY

//the same goes for Table_2

Table_2:

QUALIFY *;

UNQUALIFY ID;

LOAD

ID,

Family_Name,

House_Address

FROM YourDataSourceForTable_2;

UNQUALIFY*;