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
20 - Arcturus

@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