Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output the cell reference from Excel to column header

kmohta
5 - Atom

Hi,

 

I would like the Alteryx output to have the cell reference from which the data was extracted from Excel.

For eg., if the input data in Alteryx comes from cell B21 in Excel, I want Alteryx output to have B21 in output in the column header. 

I am building a huge database from multiple Excel files - all of which are in the same format. The workflow is extracting data from many different tables in Excel. There will be multiple users for the database. So it would be easier to have the cell reference to be able to go back and check something in Excel if needed as everyone i snot familiar with the Excel files.

 

 Is it possible to do this in Alteryx? Many thanks in advance!

1 REPLY 1
binuacs
21 - Polaris

@kmohta This can be achieved by importing the xml part of excel. please go through the below post by @danilang 

 

Re: comparing column headers and notes in header c... - Alteryx Community

Labels
Top Solution Authors