"Piggyback LOAD" - troublesome in combination with a JOIN?
I have just learnt about this kind of LOAD - well, I had read about it before, but I only really understood it now.
What I mean is things like this:
A & '|' & B as C;
E as B;
This "piggyback LOAD" just replaces a field in the table that is loaded in the main LOAD statement here so you can already access the fields only calculated in that LOAD without repeating any complicated formulas, thereby eliminating the corresp. potential for errors.
<=> It seems (we just tried this out in a scenario) that this can prove troublesome when combined with a JOIN.
=> Is that so? Can someone please shed some light on this?
Since this did not seem to work for some mysterious reason (it had worked just like this yesterday), we tried to split that formula into two separate Applymap_commands by using suc a "piggyback load" - in the table_to_be_joined. That did not seem to work.
Thanks a lot!
P.S.: Well, it seems I haven't understood it well - currently, in two instances, this replaces the entire table I have just loaded with a table that has just one field...