Make Column tools help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thanks!
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @cireost,
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.