Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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