user03839 Member


  • For those interested, I used Magic ETL, joined the two sources on the STATE column, then filtered out duplicate rows....I believe there is a more efficient way as this may temporarily greatly inflate the dataset with not explicitely stating the type of join..?
  • HA, after posting the question, I could see the nuance with my text nearby to compare - solved it. Needed to use ` and not ' for the column name. Now sorting as expected.
  • When adding the custom sort to the "Sorting" field, it has no effect. Attached is a screenshot and below is the code created in beast mode....what am I missing? @TylerC wrote:@phillipgornicki, I wanted to make sure the answer we discussed was also posted here in case anyone else had a similar question. In order to sort by…