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
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
Group By %Key;
Retrieving data ...