Pull the values from the excel table structure

Hi,

I am using an excel sheet which is formatted in a table structure and I need to pull the values from that table. Below is the image of the table in excel.

table Structure.PNG

As shown in the above image, the column value for 'PDs Non-stress horizon (yr) 85%' = 1 and 'PDs Non-stress horizon (yr) 95%' = 1. Similarly we should have the values for next four values. I tried to use transpose but that is not fetching me correct results. Can someone help me in this?

Thanks!

Input

Accepted answers

AmeliaG

Yes, this is possible if you build an app and use the interface tools. To input numeric values, use the numeric up/down and then the values will go into a Text Box tool. I've attached an example here .

sample app input value.yxwz

All comments

DavidxL

Do you have an example Excel file that you can share?

I've attached a workflow using a mockup of your data table in Excel. The main things I configured were "Start data import on line" 2 so that it skips the line "Model" and selecting the first column as the "Key Field" in the Transpose tool.

Workflow.yxzp

AmeliaG

Hi @aparanjith1,

Please note that you can read in a named range from Excel which will allow you to grab only the table data. If you are already doing this, then to get the data in the desired format, you will indeed use a Transpose tool. The 85% and 95% column will be 'data' fields and the unnamed column will be your key field (the column which contains the value "PDs Non-stress horizon").

If this doesn't work, can you please attach at least part of the Excel sheet so I can send an example workflow?/

aparanjith1

I could not able to open this WF, it says the version it has been created is more recent version. The version I am using is 11.5.1.31573

aparanjith1

Hi,

Attached is the sample excel sheet which is identical to the excel file I am using.

Thanks!

SampleExcel.xlsx

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335