Thursday, June 22, 2017

yogi_Query To Pull Select Columns Of A Large File To Be Brought In By using ImportRange Function

Google Spreadsheet   Post  #2190
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-22-2017
question by Sarvan Dharavath:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/5KFMydOQWhw;context-place=forum/docs

Filter only specific columns using importrange from one spreadsheet another spreadsheet

Hi, I am trying to import specific ranges from one spreadsheet to another using below formula (I found in Google forum), but it is not working(As it says "Result Too large") for me Please help. Below is my formula



=
QUERY(ImportRange("1evyx3-EHSIP6VRtisBBocvDqgLW_90SQWnej-i1Ug2w","Part Requirement!A:BZ"),"select Col1, Col3, Col4, Col5, Col6, Col8 where Col57 ='Need to be Delivered'")

And below are my sheets

Source sheet:

Target Sheet:
https://docs.google.com/spreadsheets/d/124p7VGvf8kmbJ1SikRtWNQ_tnFfy-Fn8cObOowZbzZ8/edit?usp=sharing