This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi - I have the following in my data load editor:
LOAD Distinctobject,// attribute,// value,DC ,UC ,LA ,ED ,DA ,OR ,CA FROM EKES.qvd (qvd);
I need help/guideline to remove dates that are duplicates.
Thanks so much - Kashif
I see you have row level data for DC column, Could be that is the reason you have aggregate data.
If you still don't want, Perhaps try Aggr(Your expression, Dimension)
Thanks for the reply, how AGGR function can be used in a load script?
Use a group by Object and LA
load object, LA,
firstsortedvalue(AD,LA) as AD,
same for the other field
group by object,LA;