Solved: Need suggestion to group rows with multiple layer ... - Page 2

CHRISTOPHE_CHAN · 01-05-2021 12:27 AM

Hi,

I’d like suggestion about the right way to manage my data. I would like to group it in a table view, like the hierarchy of the data suggests :

rows type F are “familly”
rows type O are “article”

There are 5 layers of familly : ACT, F1, F2, F3 and F4 to categorize articles.

I can’t find a way to group it properly. Any idea ?

Thanks

LeventK

Thanks for the quick feedback @CHRISTOPHE_CHANDELIE. Let me briefly explain how to do it on your own.

DATA :: SLICE

Initially create a slice of your main table with the below expression:

ISNOTBLANK([OUVRAGE])

UX :: TABLE VIEW

In your Table UX, rather than the read_only table, assign the slice that you have created above.

DATA :: COLUMNS

Expand the column structure for your read_only table. You need to add 6 Virtual columns to this table with below expressions.
N.B.: Please edit the table name (TestData) in the LOOKUP expressions as per your table schema and column structure

VC#1
Name: SEARCH_STRING
AppFormula: [ACT]&[F1]&[F2]&[F3]&[F4]

VC#2
Name: _ACT_
AppFormula:

LOOKUP(
	[_THISROW].[ACT]&"000000000000","TestData","SEARCH_STRING","LIBELLE"
)

VC#3
Name: _F1_
AppFormula:

LOOKUP(
	[_THISROW].[ACT]&[_THISROW].[F1]&"000000000","TestData","SEARCH_STRING","LIBELLE"
)

VC#4
Name: _F2_
AppFormula:

LOOKUP(
	[_THISROW].[ACT]&[_THISROW].[F1]&[_THISROW].[F2]&"000000","TestData","SEARCH_STRING","LIBELLE"
)

VC#5
Name: _F3_
AppFormula:

LOOKUP(
	[_THISROW].[ACT]&[_THISROW].[F1]&[_THISROW].[F2]&[_THISROW].[F3]&"000","TestData","SEARCH_STRING","LIBELLE"
)

VC#6
Name: _F4_
AppFormula:

LOOKUP(
	[_THISROW].[ACT]&[_THISROW].[F1]&[_THISROW].[F2]&[_THISROW].[F3]&[_THISROW].[F4],"TestData","SEARCH_STRING","LIBELLE"
)

UX :: TABLE VIEW

Open your table view and Group By in order:

ColumnName	Order
`_ACT_`	`Ascending`
`_F1_`	`Ascending`
`_F2_`	`Ascending`
`_F3_`	`Ascending`
`_F4_`	`Ascending`
`_RowNumber`	`Ascending`

Hope it’s explanatory enough. Enjoy.

View solution in original post

Need suggestion to group rows with multiple layer hierarchy