topic Re: Query Builder with Excel file with Excel Filter in Discussions

Query Builder with Excel file with Excel Filter

Françoise — Tue, 27 Feb 2018 14:16:42 GMT

hi,

i use a query builder to import an excel file. but if someone put a filter in the excel file, the query import less lines.

how to make a query builder which import all the lines even the hideen lines in excel?

best regards

Re: Query Builder with Excel file with Excel Filter

Dan_Obermiller — Tue, 27 Feb 2018 15:51:49 GMT

I just ran a simple test to verify, but query builder brings in all of the rows for me even from a filtered Excel spreadsheet.

Now if I OPEN an Excel table, the default behavior is that I only receive the filtered Excel rows. To fix this problem, in the Excel Import Wizard, click the NEXT button at the bottom of the page. Clear the checkboxes that suppress the hidden rows/columns.

Re: Query Builder with Excel file with Excel Filter

Françoise — Tue, 27 Feb 2018 16:22:05 GMT

ok,

It's good.

thanks

Re: Query Builder with Excel file with Excel Filter

Françoise — Tue, 27 Feb 2018 16:58:59 GMT

hi,

I'm using 4 filters for the same query builder to select lines.

another pb: all the lines are selected. Last week, it was OK.

explications?

best regards

Re: Query Builder with Excel file with Excel Filter

Françoise — Tue, 27 Feb 2018 17:08:18 GMT

Hi,

I use a filter which has 2 values selected.

It' OK.

when I add an another filter (on an another variable) with 2 values selected:all the lines are selected as the query builder don't use the filters.

best regards

Re: Query Builder with Excel file with Excel Filter

Dan_Obermiller — Tue, 27 Feb 2018 17:23:03 GMT

Could you possibly share an example of what you are trying to do?? It is too difficult to determine what is going wrong without that example. Thanks.