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?
