topic Qlik Sense: Fill out table with key, or rather reducing rows in App Development

Qlik Sense: Fill out table with key, or rather reducing rows

enfodavid — Thu, 14 Sep 2017 12:24:09 GMT

How do I fill out a table that has a key and all fields (Including some empty ones) but on separate rows. Desired table is just a row per key.

This is probably easy but I've drawn a total blank

enfodavid — Thu, 14 Sep 2017 13:00:29 GMT

Group By is what I'm looking for. I'm dumb

LOAD Only(%Key) as Key,

Only(Field1) as Field1,

Only(Field2) as Field1,

Only(Field3) as Field1

FROM $Source

Group By %Key;