Input Data : Replace with Full Path

Question

Hi There...

I have an Input Data called Superstore Old (B), the File Path for Superstore Old is C:\users\del\Sample Superstore Old.xls

However the Input Data file path for Superstore Old (B) needs to be replaced with a different excel that has a different path name that change regularly.

How can I dynamically replace the Input Data field in (B) to go from.....

C:\users\del\Sample Superstore Old.xls

to the new full path name shown in (A) called...

C:\users\del\Replacement Excel.xlsx|||Country

Sample Superstore Old.xls

Replacement Excel.xlsx

Input Data Name Replace.png

Input Feed in Full Path Name.yxmd

DelData · Accepted Answer

I will use a combination of dir and formulas to get the full path of the replacement excel each time name changes....I now thinking a batch macro will work....I will try that...thanks for getting back to me :)