Add column with row number to table

November 30 0
Advertisement
Hi,
to a table view I'd like to add a new column that contains the row number for each row.
I have many data sources (twelve) and with the union operator I create one output dataset. The output data is sorted by the arrangement of the input ports of the union operator.
Is there a way to add a column with its corresponding entry number?
Regards, FT
Advertisement
I have a similar question to the original post. It seems your answer will fill the new field in all rows with the same value. But, what if we want an actual row number?
I am simply looking to add a row number to a table. I only have one data source. The business scenario is that the output of the data service is sorted in descending order on value. I want to be able to select the first 10 (i.e. the top 10 items based on that value).
Even if I can solve my business scenario without using a row number field after the sort, it seems like a technique that would come in handy. 
Any ideas? I'm pretty new to using Visual Composer so I may be missing something obvious.
Add column with row number to table

Hi, to a table view I'd like to add a new column that contains the row number for each row. I have many data sources (twelve) and with the union operator I create one output dataset. The output data is sorted by the arrangement of the input ports of

Add column with preq number to ALV grid in me53n

hi all, i am trying to add column with preq number (BANFN) to ALV with preq items in ME53N. it is not available in column set, when trying to add by "change layout" button - i dont understand why, when the strcucture MEREQ3211GRID contains it :-

How do I add remove Multiple rows in a table

Guys, Can somebody tell me How do I add and remove <u><b>Multiple</b></u> rows between two tables. <u>Also, I want the row or rows to disappear from the source table as soon as it is moved or added to the second table and app

Need to add a blank row to a table when checkbox selected

Hi ALL, I have a custom page having 2 check boxes and few fields , i am doing search operation by entering one checkbox checked and few other fields and data displaying in table region. my requirement is when i select second check box and click one b

Add / Delete a row in a table without using a button

Hi, I was just wondering if it was possible to remove or add a row in a table without using the button?  I noticed that in all examples, it always involve putting code in the button click event but I wanted to add or delete a row in a table based on

SRM - Add column to Response and awards table

Hello, I have a requirement to add a column in the compare responses table (please see print attached), i've found the WDA program, that is the /SAPSRM/WDC_AODC_BEV_CMP, View: V_BID_COMP_ITEM, but the part of the table that is in the print attached i

How to calculate value from perticular column and row in pivot table

Hi all, I am having following pivot table. Country A B C D F G H J K L M Grand Total Canada 1 1 3 3 12 14 13 97 China 8 4 3 19 India 2 47 448 176 395 3656 1964 1360 8077 USA 1545 352 380 26 10 4 8 32 2054 1023 758 4624 UK 12 19 13 23 33 298 Grand Tot

Cannot select column or rows in a table

I've created two column document - but for some reason cannot select the columns so that I can format them. The selection menu items are grayed out. And when hovering with curser the curser does not convert to arrow to enable 'select'. I just want to

How to add a new row in rich table when a button clicks which isinatemplate

i am new to j developer 11g. i have problem when i click a reset button located in the template will clear all data from the rich table and it is in a add mode,ie table with only one empty row Regards rajesh Edited by: [email protected] on Mar 10, 20

Transform columns in row for a table in Oracle 10g

Hi, I am using Oracle 10g. There is a table (example) EMPLOYEE, with following structure IDUSER YEAR1 YEAR2 YEAR3 12345 value1 value2 value3 99999 value7 value6 value5 and I need display : IDUSER YEAR 12345 value1 12345 value2 12345 value3 99999 valu

Add column in the dynamic internal table

Hi Experts, I have a dynamic internal table. I need add new column in the internal table and I don´t Know. My code: DATA:  it_generic TYPE REF TO Data, wa_generic TYPE REF TO data. FIELD-SYMBOLS: <table> TYPE ANY TABLE, <wa>    TYPE ANY, <f

Add columns in the existing Customer table in a Subject Area

Hi All, Well I need to add two columns from Sales table(new table i created which has customer Id) and join it to the Customer Table which has the Customer Id and several columns. The Customer table was already in the RPD which has all the customer i

Add a new Row to a table in HCM forms and Processes

Dear All, I am haunted with the problem of adding a new line to a table on clicking a "ADD new Line" button on the Adobe form, how can this be achieved. What I have done I have created the table and followed the instruction of OSS note 1043692,

Make the column to row.(internal table)

hi i have an internal table ITAB data:begin of itab         quarters(2),        end of itab.    that has contents Q1 Q2 Q3 Q4 I would like to have a ITAB2 like this data:begin of itab         Q1(2),         Q2(2),        Q3(2),        Q4(2)        en

[CS2/CS3 JS] Inserting columns or rows in tables

Anybody here know how to insert or add column(s)/row(s) in tables in Indesign Javascript? Please help... Thanks...Hi Joaquin, you might have to take use of the add()-command: Add a column before the first column: myTable.columns.add( LocationOptions.

Hit the exception when editing the value of row key column in a new created row in a table

1. I created a view object with 2 entity objects (parent table: YARD_FIXED_SLOT - child table: YARD_FIXED_SLOT_DETAIL) and the primary key of child table composes of 2 columns ( one of them is FK: YardFixedSlotDetail.FIXED_SLOT_ID REFERENCES YARD_FIX

How to set max. number of rows in a table?

Hi, I'm working on a SCADA interface. In this application there are different tables with vertical scroll bar. I prefer to make visible only the initialized rows (I've initialized 40 blank rows of a table with a string array). Since the window not co

Create a new row in a table without using add new row button

I want to add a new row to the table without using the add new row button of the table. I'm not able to display default row in the table. Though if click on apply the record appears after saving in the database. Any thoughts how to implement this fun

Add new row to a table

Hello! I'm using JDev 11.2 and I'm trying to add a new row to a table object (using create insert) the catch is this- and the new empty row that will appear- I want a value set instead of one of the values- so the user can choose which value to inser

How to add new row to adf table progrmatically

Hi, I have a bean with a list and correspoding getter & setter methods inside it. I created a datacontrol out of the bean and I am displaying af:table in the ui binded to this list. Ex: public class StudentBean { private List<Student> students;