Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Contributor III
Contributor III

Loading Data to Load Editor

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!

Labels (1)
8 Replies
RamanaKumarChintalapati
Partner - Contributor III
Partner - Contributor III

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
Master
Master

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

or else you can rename the fields based on requirement.

nickmarlborough
Contributor III
Contributor III
Author

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
Creator II
Creator II

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
Contributor III
Contributor III
Author

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
Creator II
Creator II

Qualify*;

UnQualify ID;

LOAD Name,

LOAD Location,

From Table 1

 

Qualify*;

UnQualify ID;

LOAD Name ,

LOAD House Address,

From Table 2

 

 

nickmarlborough
Contributor III
Contributor III
Author

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

F_B
Creator II
Creator II

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*;