I noticed that the getFlexFile function does not return a "StNo". Not sure if this is an explicit omission, but I have been using the combination of Survey, Year, Quarter, Country, Ship, Gear, StNo, HaulNo to create a unique haul id in the HH, HL and CA tables. Not returning "StNo" in the getFlexFile prevents a "clean" joining of e.g. the FL-table to these other tables.
I noticed that the getFlexFile function does not return a "StNo". Not sure if this is an explicit omission, but I have been using the combination of Survey, Year, Quarter, Country, Ship, Gear, StNo, HaulNo to create a unique haul id in the HH, HL and CA tables. Not returning "StNo" in the getFlexFile prevents a "clean" joining of e.g. the FL-table to these other tables.