Reading Excel File in Alteryx

Question

Hi,

I want to use dynamic input tool to read and append the file on daily basis from

Please see below sample table from the excel sheet which i have downloaded from the tableau server :

But the output is not coming as expected in Alteryx ,it is showing lots of null value in the columns . As, I have to combine the data form multiple files on the daily basis , what is the best way to accomplish it in Alteryx. Thank you in adance!

Output from Alteryx workflow:

Alteryx Output:

Desired Output:

Thanks

Harinder

Test.xlsx

kelsey_kincaid · Answer

Hi @harinder1301 ,

To expand on @Christina_H 's post - you will want to use a Multi-Row Formula tool to fill the nulls. To fill every column, you might choose to use three different multi-row formula tools, but using a transpose tool first will make your life easier. That way, you can use one multi-row formula tool to fill every column. Also, if you add more columns in the future this approach will handle that without you needing to update the workflow. I've attached an example here!

2021-10-13 MultiRow Example.yxzp

Christina_H · Answer

The nulls are due to the merged cells in Excel.  To get the correct data in Alteryx you could either change data layout on the Tableau Server to populate all cells, change your download to one that includes them all (full data rather than summary?) or use something like multi-row formulas in Alteryx to fill down the blanks.