Moberling Member

Comments

  • I was unable to successfully make changes in the dataflow to my source data. My solution was: change the column format of my flat lookup file to match the format of 'Sold-to Industry Code'. My join worked once formats matched. I then addressed nulls via a beastmode 'ifnull' function.
    in Replacing Blank Values in Dataflow Comment by Moberling April 2020
  • Hi, Thank you ever so much for your input and my apologies on my delayed response. Attached is the image that shows the format of the column I am attempting to manipulate. I was successful in utilizing the 'String Operations' to trim spaces from this column and then convert to a whole number and then successfully perform…
    in Replacing Blank Values in Dataflow Comment by Moberling March 2020
  • Dan, Thank you very much for the thorough reply! This helps immensely. Mark
    in Use Beast Mode to Change Column Header Name Comment by Moberling March 2019
Default Avatar