Outputting the last row of multiple spreadsheets

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.

Workflow

Help

Preparation

Accepted answers

binu_acs

@LK22J attaching a sample workflow for your reference

getLast_Row_121223.yxzp

All comments

putu_w_erata

do you have a sample workflow?

binu_acs

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

binu_acs

@LK22J attaching a sample workflow for your reference

getLast_Row_121223.yxzp

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703