Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
KarthikGs
Creator
Creator

Parse Excel file to choose an entire row, by applying filter condition on a single cell

Hi all,

I need help to extract data from an excel file based on a value existing in a single cell.

 

Attached is the excel sheet, from which i want to extract the data from depending the value in the cell A.

 

0683p000009LzBu.png0683p000009LzTj.png

When my input parameter is ABS, i want to save the entire highlighted row as an output.

 

Any help is appreciated.

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@KarthikGs,read the excel file and filter based on the column A and then write it to excel output file.

 

Job loooks like below.

 

tFileExcelinput>>tFilterRows-->tFileExcelOutput