Filter Table based on a fields sub value.

[#1]

Hi

I have a table which I want to filter the information based on a field it has.

Table1:

field,

field,

field,

Assignee, <--Field I want to filter by but it has 5 different rows, ex. A,B,C... I only want to filter by B.

From

[..\..\02_QVDs\IT\][qvd]; < can I put a where clause here to filter by Assignee but its sub row 'B'?

[jagan · Accepted solution]

Hi,

Try like this

LOAD

*

FROM DataSource.qvd (qvd)

WHERE Assignee = 'B';

If it is not working then attach some sample values.

Regards,

Jagan.