![]() ![]() If there are any questions, please comment below. The un-formatted file contains in multiple rows and columns for each set of transaction. Executing this logic for the above shown excel file will result in two records as shown below :Ĭonverting columns to rows can also be acheived using the similar logic, just need to look for correct field references for the destination table. Transpose Data with the Transpose Formula This method is a dynamic solution, meaning we can change the data in one column or row and it will automatically change it in the transposed column or row, too. Reference to the particular field of the target structure is obtained and the excel value is assigned to it. Check the box next to Transpose and then press the OK button. * rollnr entry exists in the internal table, further characteristics to be added. ĪSSIGN COMPONENT ls_excl-fname OF STRUCTURE TO. READ TABLE ot_main_old INTO WITH KEY rollnr = ls_excl-rollnr. To do this, click the down arrow underneath the Paste button in the ribbon, and under the Paste heading, youll see a button that looks like a column rotating into a row. ![]() * Add entry for new rollnr in the internal table.ĪPPEND INITIAL LINE TO ot_vpemain ASSIGNING. ![]() example: data starts on row 2 of Target Sheet Make sure to check the code to see where the columns and rows begin on the source sheet. ![]() Ot_vpemain contains the converted data in the db table format.Ĭonversion logic as follows: LOOP AT ot_excl INTO ls_excl. The purpose of the TRANSPOSE function in Excel is to convert rows to columns, i.e. Copy the data to the target sheet, in the format you want Go to next Column Group Setup: You will need to create a new Sheet. There may be any number of records for one object depending upon the number of fields to be updated for that object.Ĭonversion of excel data to the table formatĭata type to hold the excel data consists of three columns only as shown above in the excel. The format of the excel file is as follows: The table contains 180 columns with one primary key. In this blog, I will discuss about how to convert excel data from row format to column format.Ĭustom table records have to be updated from the excel file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |