If problem

[eugeniyaromanov]

Hello everyone!

I have a problem I can't handle...

I need to write IF for many rows to have one row in the end

I have 2 tables:

1st Data table:

Where I can see date, time and a route.

And I have 2nd table with statuses:

Two of them is good and one is bad.

I need to understand which number is good and which is bad.

So, if all statuses are good, number is good, and if number has even 1 bad status, I need to display it as a bad number.

In the end, from this data I need table like this:

Data table:     

Number	Date	Time	From	To	Good/Bad
1	01.01.2017	00:00:00	London	Riga	Good
2	01.01.2017	00:00:00	Riga	London	Good
3	01.01.2017	00:00:00	Moscow	Vilnius	Bad
4	01.01.2017	00:00:00	Berlin	Milan	Good
5	01.01.2017	00:00:00	Madrid	Kiev	Good
6	01.01.2017	00:00:00	Kiev	Vilnius	Good
7	01.01.2017	00:00:00	Berlin	London	Good
8	01.01.2017	00:00:00	Milan	Moscow	Bad
9	01.01.2017	00:00:00	Vilnius	Riga	Bad

Please see the attach with data.

[neelamsaroha157 · Accepted solution]

Check this out

[eugeniyaromanov]

Great!

How couldn't I think of this?

Thank you!