Outputting the last row of multiple spreadsheets

[LK22J]

I am trying to output the last row of hundreds of Excel spreadsheets (.xlsx) along with a new column that indicates the name of the file where the row is coming from. There was a relevant thread from a couple years ago but I have followed the instructions tightly with no luck. The main problem seems to be with the Dynamic Input tool but I am just speculating. Have also tried the Batch Macro solution but also had no luck.

Would really appreciate if anyone would provide some insight into this, thanks in advance.

[putu_w_erata]

do you have a sample workflow?

[binuacs]

@LK22J The batch macro should work in your use-case

[binuacs · Accepted solution]

@LK22J attaching a sample workflow for your reference

[LK22J]

Thanks a lot for providing that. That was very helpful!

However, there are a minor problem on my end - in the output file, in the cell where I am expecting for example 43,123,456, I am seeing 4.3123456E7 instead. It is obviously still readable but wondering what I have done wrong.

Note: My Alteryx is limited to the 2020 version due to company policy. Is this a case of incompatibility?

[Raj]

try changing the data type to string.

It will work