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 PatronHi .. thank you for your response.... sure I have .. I use fieds from there in a number of calcs.
I could attach the workbook for you to see?
thanks
Marc
MarcUrdangPost Patron
Post Patronactually not in calcs .. just in the views
- kentyler
Solution Sage
don't understand that...
I'm going out for coffee. If you could share the file on one drive or google drive I'll take a look when I get back.
- MarcUrdang
I'm just starting to build so now much to see .. basically there is a field called Names Saiing Day in the Carrier Info table and a calculated field called 'Weekly FLL ETD ATD' in the Consol Inbound Tabl ... which I need to compare with the Names Sailing Day from the Carrier Ino Table
https://drive.google.com/open?id=1XBPsyU1Vt3bZLTALw-1_3jtqLFTjTv1U
- MarcUrdang
- kentylerOK. 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.
