Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table (left), that I would like to convert into table (right). For each item in the original list, only the values corresponding to the largest number of repetition should be displayed.
Any idea?
Michael
Yes idea is like attached sample.
You can also make this transformation during the load in edit script window. Below example based on load from Excel file (table like in your example). Not very pretty solution.. but it works;)
Load max(REPETITION) as REPETITION
,ITEM
From data.xlsx
(ooxml, embedded labels, table is Sheet1)
Group by ITEM;
INNER JOIN
LOAD ITEM
,REPETITION
,VALUE
FROM
data.xlsx
(ooxml, embedded labels, table is Sheet1);