My Day✳All blog articles ↗

Append two lists with only one header

Append compatible records while retaining one header.

When appending one list to another, its header must not become a task. Establish matching fields and meanings first. Remove only the known source header through structural reading, rather than deleting every row that looks similar.

2 sources; 3 data rows; 1 header
2 sources; 3 data rows; 1 header

What to do

  1. Compare the field names and meanings in both source lists.
  2. Append the data rows to one dataset, retaining each record’s source separately.
  3. Check the single result header and every value association against the originals.

Example

Fictionally, L1 has header id,status and rows A,open; B,done. L2 has the same header and C,open. Result header: source,id,status; rows: L1,A,open; L1,B,done; L2,C,open. The 2 lists yield 3 records and 1 header. This appends records; it does not merge edits to one object or deduplicate tasks.

My Day · Windows

Save this note manually in My Day.

Buy My Day for Windows ↗