I am trying to load some employee id from different report urls for my usage dasboard stored is an excel. My data set is
| Report name | URLs |
| RPT1 | Link1 |
| RPT1 | Link2 |
| RPT1 | Link3 |
| RPT2 | Link1 |
| RPT2 | Link2 |
| RPT2 | Link3 |
| RPT3 | Link4 |
Now I am trying to capture URLs value in a variable and use that variable as web service to retrieve employee id in that link
script is
Report_URL:
LOAD UPPER(Report_name) as Dashboard,
[URLs]
FROM
[a.xls]
(ooxml, embedded labels, table is Sheet1);
LET rowText = NoOfRows('Report_URL');
for i=1 to $(rowText) // loop through every row
let URL = FieldValue('URL',$(i));
let vDashboard = FieldValue('Dashboard',$(i));
OtherAppUSERS:
LOAD //RowNo() as %ENTTL_ID,
[@13:19],
'$(vDashboard)' as [Doc Name]
FROM
$(URL) (fix, codepage is 1252)
WHERE [@1:12] = '<EmployeeID>';
next
This is giving me some irrelevant error
The system cannot find the file specified.
OtherAppUSERS:
LOAD
[@13:19],
'RPT2' as [Doc Name]
FROM
(fix, codepage is 1252)
WHERE [@1:12] = '<StandardId>'
I guess repeated link is issue here but not sure how can i resolve this. I can create different QVD n concatenate but want to resolve this error so that if any new report comes in we dont have to change the code and can update the sheet itself
