Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'?
Hi,
Try like this
LOAD
*
FROM DataSource.qvd (qvd)
WHERE Assignee = 'B';
If it is not working then attach some sample values.
Regards,
Jagan.
Hi,
Try like this
LOAD
*
FROM DataSource.qvd (qvd)
WHERE Assignee = 'B';
If it is not working then attach some sample values.
Regards,
Jagan.