field selection

[ssriramin19]

I have a field which has many values. I have data from the excel with many values for the same field. I need to select all the values which are present in the excel  to the report.

I need not do any script changes .I need to know how to  achieve through front end selection

Thanks

Sriram

[ssriramin19]

Can you still elaboreate further? I am not able to get clear idea on this .Please explain me again

[Peter_Cammaert]

What exactly is it that you don't understand?

[ssriramin19]

How to check with exists function? Please elaborate

[ssriramin19]

Is there any function available to check the required data available or not ?I mean to write the function in the list box or in the input box

What should the formula that needs to be applied?

[its_anandrjs · Accepted solution]

Hi,

Check this simple Where Exists example

New_536_Records:

LOAD ID_Field,'ID Found' as Flag;

LOAD * INLINE [

    ID_Field

    10

    20

    30

    40

    60  

    50

];

OldRecords_9000_records:

LOAD * INLINE [

    ID_Field

    10

    20

    30

    40

    2

    50

] Where Exists(ID_Field);

Here in above only 10,20,30,40,60,50 records loaded between this two tables by using this you can use your Excel list and match it with the existing data.

Regards

Anand

[ssriramin19]

Exists can be used for checking the field values for already loaded function .Am I right ?

The approach what you have suggessted works properly. Thanks very much.