Help in Scripting

[#1]

Hi All,

I have a table as shown below:

Item	Header 2	Header 3
A	Mixed	C1
A	Mixed	C2
B	Mixed	C1
C	Mixed	C2

I wish to create the below table:

Item	Header 2	Test
A	Mixed	Y
B	Mixed	N
C	Mixed	N

Thanks,

Asma

[jagan]

Hi,

I forgot giving the group by in Load statement

left join ( Data )

LOAD

Item,

[Header 2],

If(Count(Item)>1, 'Y', 'N') as Test

RESIDENT Data

GROUP BY Item, [Header 2];