Need help with Skipping columns if not there
- 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
I am trying to create a standardized Workflow where let's say I have 4 columns (A,B,C, and D). Some companies have data in all 4 columns and some companies only have data in column B and D. How do I create a workflow that allows me to ignore and continue in the workflow if Column A and D are missing? Because later in the workflow, I do have formulas using columns A and D but if the column is missing then an error occurs. So I am trying to figure out a way to skip those formulas and have the workflow continue without it breaking every time and without me having to create multiple workflows for specific companies. I want to be able to create one workflow that I can use for all companies.
Does that make sense?
Thanks in advance!
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @gtruong
I believe that you can build a dummy header with the text input tool containing all possible headers (A, B, C, D), so even if the file does not contain the column, the formula will work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Felipe for your idea.
For my more information, Columns A-D were originally rows made into columns using the Cross Tab tool. Which tool would I use to say, If Column A is there then do nothing but if Column A is not there then create a Column A. Please let me know if that does not make sense.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @gtruong
It seems to me that you just need to do something like this. If the header from the text input is on your cross tab, it will do nothing, if it is missing it will create a column.
