Import data using sheetgo addon and query function with date filter and headers(first row of source file)


#1

How to Import data using sheetgo addon and query function with date filter and headers (first row of source file).


#2

Hi @HUMENTH

What’s your date condition?


#3

Hi
I have data in Excel from Jan-2017 but I only want to import data from Jan-2019, but when apply Condition or Query (SELECT * WHERE E >= date ‘2019-01-01’) in SheetGo addon there headers also filtered and I want headers with filtered data.
before applying Condition or Query Snapshot


#4

I am not sure I understand this part. Can you elaborate once more?


#5

@HUMENTH also on the screenshot you shared it seems like there’s a formatting issue.
image
Just select that column and go to FormatNumberDate and check if this fixes it.
:+1: