Hi - I have built a workflow using the Make Column tool to essentially transpose each column and the respective data within that column to fit nicely within a table. However, I have one tenant that has 1 extra row of data in the Building Share % column called (varies), which is throwing off the workflow. Might be easier to see input file with comment. Instead of (varies), the result should have shown 0.36%. Please advise on how I can address this.
If you modify your 2nd filter tool to exclude "varies" (!IsNull([F2]) and [F2]!='(varies)'), then the 0.36% entry will be where you expected. Question is, does it make sense to filter it out? The other streams didn't have it.