Correlation of data in the data load editor

v_n — Thu, 17 May 2018 11:35:20 GMT

Hello everybody,

I have a problem with the correlation of data in the data load editor.

In the data I have several material numbers. Every material number is related to a plant and a price.

Sometimes there is more then one plant related to a material number. Then the price differs also.

I'm loading the data from two different sources. In the first file I have the material numbers, the plant and some other information.

In the second file I also have the material numbers, the plant and the price. I'm loading the plant from the second file as Plant.File2.

Now I want to analyze the data. I have a table with the dimensions plant, material number and price.

Qlik Sense shows me then for every combination of the plants from the both files a price. I only want Qlik Sense to show me the price when the plant from the first file and the plant from the second file are equal.

In the app I can enable this with the formula if(Plant = Plant.File2, Price).

Do you have an idea how I can implement this functionality also in the data load editor?

Thank you in advance!

Best Regards,

Valentin

Re: Correlation of data in the data load editor

mikaelsc — Thu, 17 May 2018 17:23:15 GMT

create a correct relation between the data in your model;

either by creating composite keys how to create composite key

or maybe by some further modelling (join) Understanding Join, Keep and Concatenate

in more complex models, you may need link tables as well (google is your friend for this great topic)

topic Correlation of data in the data load editor in App Development

Correlation of data in the data load editor

Re: Correlation of data in the data load editor