# Log Group Extraction - When a Cell is Blank

{% hint style="success" %}
**What is Log Group Extraction?**

A feature for downloading collected information from multiple extractions (hourly, daily) all at once. Logs are created when you extract the same page more than twice. Use this feature to compile past data into a single Excel sheet.

**If blank cells appear during log group extraction, try changing the source and extracting again.**
{% endhint %}

{% hint style="info" %}
**Quick Start**

➡️ Select result log in DATABOARD ➡️ Extract with latest data as source ➡️ If blank cells appear\
select oldest data as source and extract
{% endhint %}

***

### How to Use

[https://search.naver.com/search.naver?where=realtime\&sm=tab\_jum\&query=코로나](https://search.naver.com/search.naver?where=realtime\&sm=tab_jum\&query=%EC%BD%94%EB%A1%9C%EB%82%98https://search.naver.com/search.naver?where=realtime\&sm=tab_jum\&query=%EC%BD%94%EB%A1%9C%EB%82%98)

![Screenshot](/files/19cf35e41f02611a8a96e093b02069bd2882841c)

I've been collecting data from this page for about 7 months.

* Collection period: August 19, 2020 \~ March 8, 2021
* Automatic collection every day at 4 PM
* Total of 204 log entries (all successfully extracted from the start until now, 7 months later)

The web page design suddenly changed on November 1, 2020. Please remember this date as it becomes a reference point for extracting log data below.

As of March 8, 2021, I want to compile all past data together. I'll organize everything into a single Excel sheet. This works the same way as group extraction. The Excel output varies depending on which data you select as the source.

Select the data result you want to use as the source from the 204 entries → Download log Excel

![Log selection 1](/files/134e1742ab3eab0df6ffa0a36b6bf3f7a9d8ae92)

![Log selection 2](/files/25673e2d69a9ea2486026ea78f9d284bfba75d2c)

![Log list screenshot](/files/fe17e8e239915f1a76941411120941732fa9a317)

{% stepper %}
{% step %}

### Select the Most Recent (204th) Data as Source

I'll use the most recently collected 204th data as the source and extract. The 204th data appears at the top of the Excel, with the rest appearing in ascending order by collection time. Having the 204th data at the top means I used it as the reference to find and organize data with the same pattern.

The first image clearly shows many blank cells. The dates with blank cells and dates with data are as follows:

* Collection date range with blank cells: August 19, 2020 \~ October 31, 2020
* Collection date range with data: November 1, 2020 \~ March 7, 2021

Why? Because as the log group extraction source, the March 8, 2021 data result was selected. This data has the same format as all data collected from November 1, 2020 \~ March 7, 2021 — the web page design was identical throughout this period, so the data formats were also identical.

![Result when using recent data as source 1](/files/e5aa4be4ae62b090c1a7221d8b237c36e981c437)

![Result when using recent data as source 2](/files/d90f2346a727829cd3d57020a99f700799b3ef0d)
{% endstep %}

{% step %}

### Select the Oldest (1st) Data as Source

To get the data that appeared as blank cells (August 19, 2020 \~ October 31, 2020), select a data result from that period as the source and download the log Excel. In this example, using the 1st data (collected August 19, 2020) as the source produces the opposite results:

* Collection date range with data: August 19, 2020 \~ October 31, 2020
* Collection date range with blank cells: November 1, 2020 \~ March 7, 2021

![Result when using oldest data as source 1](/files/87e1fe7c034de1761799ac01987131071f56a064)

![Result when using oldest data as source 2](/files/b7ee6fc8fe0a94b790fb166c1469c9c18a3099d4)
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.listly.io/getting-started/databoard-features/log-group-extraction-blank-cells.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.