topic How to not display certain information in a table in App Development

How to not display certain information in a table

Manuel174102 — Mon, 22 Aug 2022 08:30:03 GMT

Hello Everyone,

I have the following table

Num	Line
1	10000
1	30000
2	20000
2	40000
3	10000
3	50000
3	10000
3	20000
4	10000
4	20000

and I just need this :

Num	Line
1	10000
2	30000
3	10000
4	10000

I need to only keep the smaller "LINE" for each number. Can I do it in the front end? or should I do it in the back end?

Thanks

Re: How to not display certain information in a table

brunobertels — Mon, 22 Aug 2022 09:17:58 GMT

load

Num,

min(Line) as Line

from ...

group by Num ;

Re: How to not display certain information in a table

BrunPierre — Mon, 22 Aug 2022 09:40:58 GMT

Is your output suppose to display the first row of each Num field value? If so then, try this

Temp:

LOAD Num,
Line,
RowNo() AS ID

From Table;

FinalTable:

LOAD Num,

FirstSortedValue(Line,ID) as Line

Resident Temp

Group by Num

Order by Num;

Drop Table Temp;

Exit Script;

Re: How to not display certain information in a table

Manuel174102 — Mon, 22 Aug 2022 09:29:54 GMT

hello!

it is not working 😞

i get the following message:

The following error occurred:

Unexpected token: 'min', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...

The error occurred here:

Load VR >>>>>>min<<<<<<(Line No_) as Line from Sales_Invoice_Line GROUP by VR

when I write min( it gets red

Re: How to not display certain information in a table

Lakshminarayanan_J — Mon, 22 Aug 2022 09:40:48 GMT

@Manuel174102

For data Model ,Kindly make use of the script posted by @brunobertels

For front End ,Kindly use the below one as mentioned in the screenshot,

Re: How to not display certain information in a table

Manuel174102 — Mon, 22 Aug 2022 09:34:18 GMT

hello!

when i write that i get this

The error occurred here:

Table: LOAD VR, "Line No_", RowNo() AS ID From Sales_Invoice_Line

Table should be the table from which I am getting the information from?

Re: How to not display certain information in a table

Manuel174102 — Mon, 22 Aug 2022 09:42:24 GMT

HELLO,

thanks. I still get all of them.... i want to delete the ones that are not min ((i did what u told me in the front end)

Re: How to not display certain information in a table

Lakshminarayanan_J — Mon, 22 Aug 2022 09:44:16 GMT

@Manuel174102

can you post the screenshot of table

Re: How to not display certain information in a table

Lakshminarayanan_J — Mon, 22 Aug 2022 09:47:31 GMT

@Manuel174102

Can you try the below expression and share the result if not working.

=Min( total <Num> Line)

Re: How to not display certain information in a table

Manuel174102 — Mon, 22 Aug 2022 11:40:35 GMT

It still does not work 😞

Re: How to not display certain information in a table

BrunPierre — Mon, 22 Aug 2022 11:51:53 GMT

@Manuel174102 as @Lakshminarayanan_J suggested you may have to share specific details as to why it doesn't work for you because all the suggestions seem correct.