Reading data from a specific cell in a spreadsheet

[MadhavTR]

My data source is an excel spreadsheet which has data from line 12.

There is another cell above line 12 for example cell 6c which I am also interested to read. How can i read data from that particular cell when i am importing from data on line 12?

[Luke_C]

Hi @MadhavTR 

I assume you are setting the starting row in the input tool configuration. There are two potential options:

1. Use two input tools, with the second isolating the cell you want to read using the select records + select tool
2. Use one input tool and branch off to:
   1. isolating the cell you want to read using the select records + select tool
   2. Using a sample tool to skip the first 11 rows and a dynamic rename to bring the headers up from the first row

[binu_acs · Accepted solution]

@MadhavTR another way of doing this

[MadhavTR]

Hi Do you also know how to maintain a mapping file in the workflow? for example one of my column has supplier name and i have a 2 column mapping file with supplier name and number. I want to add another column to add supplier number based on supplier name.

[Qiu]

Try Join tool.