Filter on data

[ranibosch]

Hi,

I've got the following table:

Creation Day	Creation Month	Posting Day	Posting Month	Item No	Document Number	PO Number
1	Jun	1	Jun	PLWPEC002B	GRN042628	PO032791
1	Jun	30	May	FRUCOC001	GRN042678	PO033054
1	Jun	30	May	OIL03	GRN042622	PO032790
1	Jun	31	May	L100X107-0065	GRN042630	PO032879
1	Jun	31	May	L100X107-0118	GRN042679	PO032879
1	Jun	31	May	PEC001C	GRN042677	PO033115
1	Jun	31	May	PEC002C	107126
1	Jun	31	May	PEC002C	GRN042677	PO033115
1	Aug	1	Aug	PBWALM005/100	107166
1	Aug	1	Aug	PBWALM005/100	GRN043866	PO033057
1	Aug	1	Aug	PBWALM005/100	GRN043868	PO033057
1	Aug	27	Jul	FRUAPPL002/001	GRN043853	PO033065
1	Aug	27	Jul	FRUAPR002/001	GRN043853	PO033065
1	Aug	27	Jul	FRUITMIX001	GRN043853	PO033065
1	Aug	27	Jul	FRULOL001	GRN043853	PO033065
1	Aug	27	Jul	FRUPEA001	GRN043853	PO033065
1	Aug	27	Jul	FRUPEA003	GRN043853	PO033065
1	Aug	27	Jul	FRUPEAR	GRN043853	PO033065

How can  I filter this data on the object / script to show only document numbers that start with "GRN"?

I do not want to see the numbers highlighted in red.

[shraddha_g]

Add below condition in script

Load *

From ....Source

Where wildmatch("Document Number",'GRN*');

[karthikoffi27se]

Hi Rani

In Object level you can use the wildmatch like GRN*

Many Thanks

Karthik

[Anil_Babu_Samineni · Accepted solution]

In script:

Load * From Table where WildMatch([Document Number], 'GRN*');

OR

Load * From Table where [Document Number] Like 'GRN?';

In front end:

Only({<[Document Number] = {'GRN*'} >} [Document Number])