Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Awesome, thank you!