Alteryx Excel Output
- 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
Is there any way we can leave a column while writing output in the excel file? Let's say I have to write a particular output in the range A-X but want to leave column T as it is a formula based column ( nothing to be written on that). Is it possible?
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The easiest would probably be to force the column to be nulls values with a formula tool - you can move it around with a select tool to place it the right place afterwards
- 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
Thank you @binay2448 and @Nanoq for the quick help. But actually, this is not helping me as I have a pre-defined output format and one of the columns is Excel formula-based. If I am trying to mark it as Null() in the alteryx then it is removing the formula from the Excel within that defined output range
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can divide the output in two parts and take two outputs on same sheet 1st A to S and 2nd U to X.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
is it possible for you to attach a workflow showing the problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Nanoq , The process and the data is confidential but if you can see the attached file. Assume that I have a pre-defined format column A,B,C & D. Column C has formulas defined for each row. When I am trying to export data from Alteryx in the range A-D, the formulas are getting replaced by Null() by alteryx. This is my problem. I want to retain those formulas because that column wont have any values from ALteryx. and I cant move the column to the end. Hope you understand my problem
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You @binay2448 . This worked for me
I have another question as well about where I am getting stuck at the moment. So, If you see the attached file, column B has the dropdown list defined and when I am writing data through Alteryx this validation goes away. Even after trying to skip this column like above method I am not able to resolve this.
