Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is aql?, how do you restrict unecessary associations ?

what is aql?, how do you restrict unecessary associations ?

2 Replies
swuehl
MVP
MVP

Could you give the context for 'aql'?

http://en.wikipedia.org/wiki/AQL

or something different I might be ignorant for.

You can restrict unnecessary associations in your data model (assuming that's what you're talking about) by renaming fields. Only fields in different tables with same field name will be associated.

Use AS to rename fields in your load:

T1:

LOAD

     Customer,

    Country as CustomerCountry, //breaking association here

...

FROM ...;

T2:

LOAD

     Vendor,

     Country as VendorCountry,

...

FROM ...;

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

When are you going to start doing your own homework? You may be able to collect the answers to your exam here, but you will not have learned anything.


talk is cheap, supply exceeds demand