$ Sign Convention in Loading Script

[#1]

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;

• Like Show 0 Likes(0) Reply
• Actions

[sunny_talwar]

Have you tried adding single quotes around the variable?

(ooxml, embedded labels, table is ['$(vsheetName)']);

[jpenuliar]

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.