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 anyone please guide me on how to proceed on this

[its_anandrjs]

Hi,

May be you can use Concat function.

Regards

Anand

[ssriramin19]

How to go about that?How to use concat function in the front end ?

[Peter_Cammaert]

What's the other source of values for this particular field? Is there any characteristic that is linked to this field and that is different depending on the source of field values?

Note that the UI treats all values as one big pile of data. Too late to figure out where individual values came from if you forgot to mark or associate them in the script.

Peter

[ashfaq_haseeb]

Hi,

Can you post sample data with expected output?

Regards

ASHFAQ

[Peter_Cammaert]

One possible solution may be:

Select all possible values in the excel and copy them to the clipboard. Make sure they're separated by spaces only.

Now in your UI, activate the listbox that shows the field in question, and open the search box (press "space" for example). Paste the list of values in the search box, and press Enter. All values selected...

[ssriramin19]

The attached picture is the list box which contains more than 9000 records. I have data in excel with the same field values .Thenumber of records in the excel is around 536 records. I cannot keep selecting each 500+ records manually .Is there a way out to check if the 536 records are part of 9000 records or not ?

Is there way to achieve in front end ?

[ashfaq_haseeb]

Yes look at where Exists function

Regards

ASHFAQ

[ssriramin19]

where exists can be used in list box ?Also I need to use the quotes , ' ' manually for field values .I assume it is time consuming .