jessymarteen Member

Comments

  • Oh my gosh, of course! You are completely right, I removed the ELSE 0 and it's no longer counting the extra. That being said, I'll go back into the ETL and adjust for duplicates there so the beast modes removing duplicates aren't necessary, thanks so much for your insight!
    in Distinct Count with Case statement not working Comment by jessymarteen August 2023
  • Sorry, I may have misunderstood your questions, Iadded the Flag column here just for context so you can see that the value is 0 but the calculation is resulting in 1. I would expect the calculation to result in 0 as well.
    in Distinct Count with Case statement not working Comment by jessymarteen August 2023
  • Hi! In the data table, there is a possibility of duplicate rows so that's why I've set up the distinct count. This is a helpful call out though, I'm guessing it would be best to remove the duplicates in the ETL vs solve for this in a beast mode?
    in Distinct Count with Case statement not working Comment by jessymarteen August 2023
  • I figured out way to resolve this so sharing in case someone else has the same issue! DO YOU REQUIRE ADDITIONAL OPTIONS? select Yes ENTER XPATH EXPRESSION The only XPATH expressions that would work for me was to specify the child nodes to import (example: //Name). I couldn't include the path (example: //allData/unit/Name…
    in How do I use the XML Advanced Connector to return cdata? Comment by jessymarteen June 2023
  • Hi Samantha, thank you for your response! I have tried all three parsers and each return the columns (example: "allData_unit_Name", "allData_unit_number", etc) but not the rows of data. As far as utilizing the xpath field goes, I have tried several combinations of things like the below but none have worked:…
    in How do I use the XML Advanced Connector to return cdata? Comment by jessymarteen June 2023
Default Avatar