topic Re: Change how the records are showed in table in App Development

Change how the records are showed in table

OrbytaQliker — Wed, 25 Oct 2023 08:51:57 GMT

Hi everyone,

I have a table with the following records, in which each record belongs to its column, and in other columns will be empty.

[01,02,03,04

7090,$(null),$(null),$(null)

X090,$(null),$(null),$(null)

$(null),5090,$(null),$(null)

$(null),X090,$(null),$(null)

$(null),$(null),0090,$(null)

$(null),$(null),X090,$(null)

$(null),$(null),$(null),X090

];

But I'd like to show the data in the following way. Each column should have its records shown from the first row of the table, instead of having a lot of empty space.

[01,02,03,04

7090,5090,0090,X090

X090,X090,X090,$(null)

];

is this possible by changing table properties or should I need work on the load script?

Thank you very much if you could dedicate some precious time to helping me.

Re: Change how the records are showed in table

maheshkuttappa — Wed, 25 Oct 2023 16:53:50 GMT

Need to do it in script, something like this

T:
Load
trim(01) as 1,
trim(02) as 2,
trim(03) as 3,
trim(04) as 4;
Load * Inline
[01,02,03,04

7090,$(null),$(null),$(null)

X090,$(null),$(null),$(null)

$(null),5090,$(null),$(null)

$(null),X090,$(null),$(null)

$(null),$(null),0090,$(null)

$(null),$(null),X090,$(null)

$(null),$(null),$(null),X090

];

Re: Change how the records are showed in table

barnabyd — Wed, 25 Oct 2023 20:16:51 GMT

G'day @OrbytaQliker,

The problem appears to be that you are trying to display values from different rows in the data table onto the same row in the display table. I have two ideas to investigate:

Table Join in the Load Script: separate each column into it's own table and then outer join the tables together. This would work only if you have other key columns to join on
Aggregate in UI table: use the chart function firstsortedvalue() to allow the table to consolidate the rows

My preference would be to find a way to reshape the data in the load script. Where did the data come from? This looks like data that has been concatenated together from different source tables. Maybe need to do table joins rather than concatenate.

Cheers, Barnaby.