topic Re: Combine Two Records with different values into one record in QlikView

Combine Two Records with different values into one record

Mon, 04 Jan 2016 21:34:10 GMT

Hey Guys:

I am having difficulties to combine two records into one in my script.

I am trying to do the following.

Thanks,Branislav

maheshkuttappa — Mon, 04 Jan 2016 22:32:05 GMT

Hi, try group by

‌load

ID_KEY,

GENDER,

sum(value)

resident orginaltable group by ID_KEY,GENDER;

sunny_talwar — Mon, 04 Jan 2016 23:36:54 GMT

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;

sunny_talwar — Mon, 04 Jan 2016 23:39:37 GMT

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

];

Thu, 07 Jan 2016 20:07:05 GMT

Thanks guys, I ended up doing exactly what you have proposed. It works great.