putting values between two tables and two conditions - query editor

[skopcak]

Hello,

Can someone please advise how to deal with this situation between the two tables?

thank you for answer

Table 1

Date	Katalog	piece	result
2017-02-05 10:45:00	10000	1	1
2017-02-05 23:16:00	10000	4	2
2017-02-06 23:06:00	50000	1	1
2017-02-07 17:06:00	50001	2	1
2017-02-07 17:06:00	8000	1	1
2017-02-08 14:51:00	400	3	1
2017-02-09 11:00:00	10000	1	3
2017-02-09 11:00:00	50000	1	2

Table 2

Katalog	Stock	Result(1) – (if Table1[Katalog] = Table2[Katalog] and Table1[result1] = 1 Then Table1[piece])	Result(2) – (if Table1[Katalog] = Table2[Katalog] and Table1[result1] = 2 Then Table1[piece])	Result(3) – (if Table1[Katalog] = Table2[Katalog] and Table1[result1] = 2 Then Table1[piece])	Result(4) – (if Table1[Katalog] = Table2[Katalog] and Table1[result1] = 2 Then Table1[piece])
400	5	3
8000	2	1
10000	1	1	4	1
50000	1	1	1
50001	1	2

[Anonymous]

Hi @skopcak,

I am not clear about that how you get result in table 2 by using table 1, could you please describe more details about the formula of red part?

Thanks,
Lydia Zhang