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.
What to do
- Compare the field names and meanings in both source lists.
- Append the data rows to one dataset, retaining each record’s source separately.
- 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.