helloo,
I have 2 tables, one containing data about a driver’s attendance, including date, driver’s name, construction site, loading location, and unloading location. The other table contains data about quarries: start date of the construction site, end date of the construction site, loading location, unloading location, site, and client’s kilometers. I want to use the QUERY function to bring the client’s kilometers into the first table based on this information, but I can’t figure out what’s not working.
If I have the conditions set as follows: the start date of the construction site is before the date the driver was logged, the end date of the construction site is after the date the driver was logged, the loading location matches the loading location in Table 1, the unloading location matches the unloading location in Table 1, and the construction site matches the construction site in Table 1.
I want one single value based on these conditions because in tabel 2 i have multiple construction sites.
1 Like
So what result do you get at the moment?
Note that the Query column by itself won’t give you any data. At the very least you will need a Single Value column that fetches the Kilometers value via the Query column.
If you can’t get it working, then a screen shot of your data, as well as how you currently have the Query configured would be useful to help troubleshoot.
1 Like
So it looks like your Query column is working.
Did you try adding a Single Value column to fetch the KM value via the query?
1 Like
Thank youu. It works now.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.