Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When we are using the inputfield we are getting error as Duplicate Key using input field and relaod is getting failed.
Note: We are using the input field against the Resident table.
Any idea when we will be getting error.
We are using QlikView 10 version.
Can you upload an QVW example?
Thanks,
Mickaël.
Hi,
at first, do you have version 10, SR2? Can you upload the part of your script? Remind, that inputfields can only entered in ONE table at the end of the script, like:
Data:
Load Field1,
...,
Field2 as Inputfield, // or 0 As Inputfield or '' As Inputfield
...
Resident Table;
Hi there, I have run across the same script error, it basically means that you have two or more identical rows within the same table, causing qlikview to be confused on how to assign the same inputfield value to a number of those identical rows, it is impossible for qlikview to make that decision beause of the associative model. The solution I found is to aggregate the data by all the dimensions within the table, in order to guarantee one single row for each dimension combinations, like this:
inputfield Amount;
Load dim1, dim2, dimn, sum(Amount) as Amount
from A
group by dim1, dim2, dimn;
Notice the the group by statement can cause qlikview to use a lot of RAM memory when working with large amount of data, also, the reload time may degrade significantly.
Regards
Hi Ivan,
I had a similar issue during one of the application buildout. We later noticed that the field name we were declaring at inputfield had presence in more than one table and we had to rename the field name.
Please check for any duplication of field names.
Regards,
Raghav
Thanks for your response Ivan
I am yet to check the data duplication. Will check and update u