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!
@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