This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
you could use a Batch Macro to read the files. In the Macro, add a RecordId, use a formula to create an OrderId field (e.g. set the OrderId to 1 for RecordId 42, OrderId 2 for RecordId 37). Then filter only records with an OrderId. See attached workflow for a (very simple) example.
do you pass "*.xlsx" as a parameter to the BatchMacro or single file names? Macro will only work, if you pass the filenames one by one. The mismatch between RecordId and recordnumber in your screenshots is a little bit confusing,