Forum Discussion
MarcUrdang
Post Patron
Post PatronComparing a field from one table with a field from another table. ie IF(X=Y,"true","false")
Please can you advise how to compare a filed in one table to a field in another table. ie If(x=y,"true","false"
MarcUrdangPost Patron
Post Patron
kentyler
Solution Sage
Solution SageOK. I got the file.
So. First question. It looks like the CONSOL Inbound describes one or more events happening for a cargo of some kind that is shipped on multiple carriers. What kind of report are you aiming at ? Is there more than one event per row in the CONSOL Inbound table. If so, which fields belong to which events. Or do you consider the whole shipping process to be just one event.
Another way to approach this would be to make a mock up of the report you want to end up with in excel, and send me that file.
- MarcUrdang
Hi ... yes agreed. I am a seasoned Tableau user. I understand well the points you are making. I don't mean to sound arrogant :) but all I am trying to do is see if the DAY of the Named Sailing Day and the DAY of the Weekday calc is the SAME or DIFFERENT. But can't seem to get this to work. I haven't started to build too much as this premise is key to a lot of my builds.
tx
Marc
- MarcUrdang
I guess all I'm trying to do is compare if the WEEKDAY of the one is the same as the WEEKDAY of the other
=IF(WEEKDAY('Carrier Info'[Named Sailing Day] = WEEKDAY('Consol Inbound'[Weekday LLD ETD ATD],"same","different")