Table line selection

[louise119]

Hi, I'd like to use table chart.
How do I extract a specific row of data? Any examples would be helpful.

[rubenmarin]

Hi, What do you mean by "extract"?

In script you can add a field using "RowNo() as RowId", so each row has a different value, adding this field to the table will allow the user to select in this field, which will reduce the table to show only the selected field (this also depende on what kind of expression are being used); and after a row is selected you can export the table to extract the data.

you can also avoid the use of the RownNo field and let the user to use the current dimensions to filter until only one row is shown.

[louise119]

Thank you for your answer.

I have just finished numbering the rows in the table chart using "RowNo(total)".
Is it possible to click on a row number to display all of  the column items in that row as text on the screen?

By pressing down on a row number, I'd like to get all column items for that row and display them on the screen using "text" of "text and Images".

[rubenmarin]

Hi, yes, you can use text object but you will need to create the expression that merges all fields, like:

Field1 & ' ' & Field2 & ' ' &Field3...

[louise119]

Thank you so much.

I'd like to press a line number like screen capture below and then, display the column items of  that line in a text object. This is what I would like to do, is it possible?

[rubenmarin]

Hi, yes, you only need to enclose the text object expression in a condition to check selections, like:

If(GetSelectedCount(RowNoFieldName)=1, Field1 & ' ' & Field2 & ' ' &Field3...)

[louise119]

Sorry for asking so many times..

Is this the correct script for assigning line numbers?
The following only allocates up to 200(or something). Can I assign an unlimited number of rows?

Load RowNo() as RowId
AutoGenerate 200;

[rubenmarin]

That only creates 200 because the "AutoGenerate 200", that tells to generate 200 rows.

In your case this should be included in the data table, where all other fields are loaded, adding a new field RowNo() as RowId to the others already loading, in the same table.

LOAD Customer,
  City,
  ...,
  RowNo() as RowId
From/Resident/SQL...

[louise119]

Thank you,
I added a new field "RowNo() as RowId" to the others already loading.
But the same number repeat. I'd like to uniquely determine it as a table key.....

[rubenmarin]

Hi, if you add it in the cities table there should be a different number for each city, you need to add the field in the main table wih the facts.