- Last Active
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.
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…