Create a new field based on values 'Yes' or 'No'

[karan_kn]

Required to create new field based on Yes or No values.

Sample script
LOAD * INLINE [
ID, Option
1, Y
1, N
1, Y
1, Y
2, N
2, N
3, Y
3, Y
3, N
4, N
4, N
4, N
5, N
5, Y
6, N
7, N
7, N

[sunny_talwar]

New field or new row?

[karan_kn]

New Field

[sunny_talwar · Accepted solution]

Try this

Table:
LOAD * INLINE [
    ID, Option
    1, Y
    1, N
    1, Y
    1, Y
    2, N
    2, N
    3, Y
    3, Y
    3, N
    4, N
    4, N
    4, N
    5, N
    5, Y
    6, N
    7, N
    7, N
];

Left Join (Table)
LOAD ID,
	 MaxString(Option) as NewField
Resident Table
Group By ID;