Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please Help me with my Script, I am trying to import Sheets from Xcel File , based on the it's Name stored in the Sheet, It is showing error When it's picking up the Sheet name in the Code (Marked as Bold).
NurturingOps:
LOAD [Ops Name]
FROM [lib://Nurturing (win-gt1ds6k1q8k_administrator)]
(ooxml, embedded labels, table is [Ops Name])
Where len([Ops Name])>0
;
countops:
Load count(distinct [Ops Name]) as "Ops Count"
resident NurturingOps;
Let vcountops=peek([Ops Count]);
drop table countops;
for i=1 to 1
//Let vOpsname=peek([Ops Name],$(i),NurturingOps);
LET vsheetName = purgeChar(purgeChar(peek([Ops Name],$(i),NurturingOps), chr(39)), chr(36));
'$(vsheetName)':
CrossTable([Opps Remark Date],[Nurturing Remark])
LOAD [Trip ID],
[42584.0]
FROM [lib://Nurturing (win-gt1ds6k1q8k_administrator)]
(ooxml, embedded labels, table is [$(vsheetName)] );
next i;
Have you tried adding single quotes around the variable?
(ooxml, embedded labels, table is ['$(vsheetName)']);
Hi Paranjal,
see in Debug Mode what is the value of vsheetName.
probably "LET vsheetName = purgeChar(purgeChar(peek([Ops Name],$(i),NurturingOps), chr(39)), chr(36));" is not returning a value.