SnapLogic - Integration Nation

i have to fetch records based on lookup values in one of the excel from other one.

actually i have two excels where one is static and other is dynac where need to fetch values matching on 3 values from static . select * from static where colum1=(select columns 1 from dynamic) and colum2=(select columns 2 from dynamic) and column3 =...

how to fetch all records in filereader snap while validating pipeline ? means i have 600 rows in a excel which i need to get in output view of filereader snap which is followed by a Excel parser ??

zipfile reader snap doesn’t showing any content only file names inside in that zip folder. what should i do retrieve the content without any account setup ???