user03839 Member

Comments

  • 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..?
    in How do I lookup data from another data source? e.g. Validate US State abbreviation Comment by user03839 October 2017
  • 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.
    in Custom sorting axes Comment by user03839 October 2017
  • 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…
    in Custom sorting axes Comment by user03839 October 2017
Default Avatar