Single code for One title

[Haritha7]

Hi Everyone,

 I have single table data like :

Title	Code
Books	we12
Books	we13
Books	we14
Books	we15
Pens	rt25
Pens	rt26
Pens	rt27
Pens	rt28
Bag	op78
Bag	op79
Bag	op80
Bag	op81
Bag	op82

Output would be like:

Title	Code
Books	we12
Pens	rt25
Bag	Bag

I have to show every unique Title with one Code only in result table.

Thanks in Advance, 

Haritha. 

[steeefan]

How would you identify the code which should be shown?

[jochem_zw]

Try something like this an expression in a table

Dimension = Title

Measure = Only({<N={1}>}Code)

in Script create field N with 'AutoNumber(Code,Title) as N', and by using this field only the first title will be showed

[Ahidhar]

you can try this in script

tab:
load Title,FirstValue(Code) as Code group by Title;
load * inline
[
Title, Code
Books, we12
Books, we13
Books, we14
Books, we15
Pens, rt25
Pens, rt26
Pens, rt27
Pens, rt28
Bag, op78
Bag, op79
Bag, op80
Bag, op81
Bag, op82
];

[Haritha7]

Hi Steeefan,

Any code we have to show either 1st (or) Middle one (or) Last one. But, every unique title gets only single code not multiple codes.

Thankyou,

Haritha.  

[Haritha7]

Thankyou 😊

[Haritha7]

Thankyou Ahidhar 😊

[steeefan]

It's still not clear to me how you would identify which code to show for which title.

[vinieme12]

kindly close the thread by accepting @Ahidhar  response as soluion