Unique record entry

[#1]

Hi,

I have a table of items; these items can exist in multiple countries.

I need a table that shows only one line per item with three columns - one for English Descirption, German Description and French description.  Essentially, I only want a table with four rows; currently I am getting twelve.

Any help would be appreciated; thanks in advance.

C

[swuehl · Accepted solution]

Hi,

try

ItemsStep2:

Load

Item,

    only(if(Country = 'UK', Description)) as UK_Description,

   only(if(Country = 'Germany', Description)) as German_Description,

   only(if(Country = 'France', Description)) as French_Description

resident ItemsStep1 group by Item;

DROP table ItemsStep1;

[#3]

Awesome, thank you!