Joining Tables

[crmarley20]

Hello, 

I need your help please, I have two tables resulting from two searches and I need to join these two tables to make a cumulative bar chart according to date.

My tables are 

crmarley20_0-1644425055153.png

crmarley20_1-1644425077542.png

What I want to achieve is:

Datum	A1	A2	A3	A4	A5	A6
2022-02-08	5.7		3.7	1.9	4.56	90.3

[BahadirS]

Hello

You have two different formatted tables. You might want to transform the structure either on first search or second. 

first_search
| join type=left Schicht_Datum [ second_search | untable Schicht_Datum segment mid_result ]
| xyseries Schicht_Datum segment mid_result

[VatsalJagani]

Something like this:

<first table's search> | chart sum(mid_result) over segment
| append [| search <second table's search>]
| stats sum(*) as * by Schiche_Datum
| rename Schiche_Datum as Datum

Kindly ignore typos and fix column names if I mis-typed it.

[ITWhisperer]

What are your two searches?