topic Re: How to access cell values from table data view? in Developer

How to access cell values from table data view?

Anonymous — Tue, 16 Feb 2021 16:23:54 GMT

I've got a simple table from which I want to get some values by accessing the table cells via row index and column index.

Unfortunately I've got no clue how I can achieve this...

I'm messing around in visual.ts with some TS code, but don't know what properties of the table dataview I have to use.

Is it even possible with the table dataview? Or do I really have to go the categorical way?

I don't need any aggregation (like sum), just the values...

Any help is welcome, thanks in advance!

Re: How to access cell values from table data view?

dm-p — Wed, 17 Feb 2021 19:48:12 GMT

Hi @Anonymous,

The details of the table data view mapping are supplied in the docs, including some output based on a sample dataset, but to break this down further:

You can access rows as table.rows[x] where x is a 0-based index, exactly like a JavaScript array.

Each row is an array of column values, so table.rows[x][y], where y is the index of the column you want the value for.

If you need to know which index represents which column, the column metadata is in the table.columns array. The index of each item corresponds with the index in the resulting rows array.

So, for example if your table.columns[0] entry represents 'Jahr' then table.rows[x].[0] will be the value of 'Jahr' for the given row entry.

Regards,

Daniel

Re: How to access cell values from table data view?

Anonymous — Thu, 18 Feb 2021 11:55:34 GMT

That helped. Thank you, dm-p!