Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys:
I am having difficulties to combine two records into one in my script.
I am trying to do the following.
Original Load | ||
ID_KEY1 | Gender | Value |
1234 | Male | 9 |
1234 | Male | 1 |
Solution | ||
ID_KEY1 | Gender | Value |
1234 | Male | 10 |
Thanks,Branislav
Hi, try group by
load
ID_KEY,
GENDER,
sum(value)
resident orginaltable group by ID_KEY,GENDER;
Mahesh's solution is correct, but make sure to use the correct casing because QlikView is case sensitive:
FinalTable:
LOAD ID_KEY1,
Gender,
Sum(Value) as Value
Resident Table
Group By ID_KEY1, Gender;
DROP Table Table;
This will also work:
Table:
LOAD ID_KEY1,
Gender,
Sum(Value) as Value
Group By ID_KEY1, Gender;
LOAD * Inline [
ID_KEY1, Gender, Value
1234, Male, 9
1234, Male, 1
];
Thanks guys, I ended up doing exactly what you have proposed. It works great.