is there any component in xcelsius which can help to search a name from excel sheet?

[Former Member]

hello

i have a excel sheet with thousand of records.

I am trying to search a name in xcelsius dashboard 4.0.

is there any function or components that can help to perform this search?

regards

Hiren

[Former Member]

I think there is no component available for what you are looking for Harry. However, you can use a input textbox and use the value entered by user to have an excel search. Try function INDEX for the same. Tutorial for the same is given on the link:

http://office.microsoft.com/en-in/excel-help/index-function-HP010069831.aspx

[Former Member]

Hi Hiren,

Well I don know if i capture your requirement but anyway I am attaching an xlf file which should work.

Thanks & Regards

Fazith

Simple Search.txt.zip

[Former Member]

Hi Hiren,

I guess you want to achieve some key figure for the corresponding name (Ex: Region name, sales).

In such case you can use the Vlookup function as in below image and find the sales and display the text using a 'Label' component.

If not the case, try to elaborate your requirement!

[Former Member]

well thanks for you response...but i guess vlookup will not fit my requirements.

my requirement is such that where user selecets year, type of race and than types his/her name to search his/her performance record.

i am uploading an image, it might giv you batter idea...

[Former Member]

i forgot to mention that this whole selection process is performed in dashboard only. and i have my data in in three different column that you can see in the below image.

[former_member190855]

Hi Hiren

Add a column before the Race and enter the formula = B2(race)&C2(Name)&D2&E2

Basically concatenate all the columns. Copy the formula to all the way through to end of your result set.

Then concatenate the destination cells from your search parameters in the same order.lets say  G2

Add a combobox and map the labels to A2-An which is the concatenation column in your data set and insertion type = filtered rows

Source = your original data set

Destiantion = same 4columns and number of rows based on your estimation of max how many rows can be the result set of your search. The in behavior tab of the combox, bind selected item=label and Label to the concatenation G2 .

Try this and let me know if you have questions.

Runali

[Former Member]

Hi Hiren,

It's not possible... to "search" for the name .

It's possible to select or view the names from excel... ( use any selector components depends on the requirement and data records..)

Regards

Subbarao

[arijit_das]

match / vlookup / hlookup functions are there in excel which are supported in xcelsius.

[Former Member]

Hi ,

There is No such type of Components available in Xcelsisus,

But you can Use Vlookup Function in Excel sheet to find out the particular record with the help of ID.

Excel's VLOOKUP function, which stands for vertical lookup, can help you find specific information in large data tables

Regards

NK