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
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.
ok,
It's good.
thanks
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?
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.
