Field name with space issue

Wed, 04 Dec 2013 23:59:42 GMT

Hi guys,

I am writing this script

NoConcatenate

[$(vCustomFieldName)]:

LOAD TxnID, CustomFieldValue as [$(vCustomFieldName)]

From [$(Path)$(_CompFileName)_v_CustomFieldsForTxnNames.qvd]

(qvd)

Where CustomFieldName = '[$(vCustomFieldName)]';

It works when the value of vCustomFieldName does not have any space in between. when it has space then the

"WHERE" clause does not work.

Can you plz suggest me that what should be right statement of hwere caluse when we spaces in value of vCustomFieldName.

Regards,

Saurabh

Re: Field name with space issue

hic — Thu, 05 Dec 2013 06:45:44 GMT

You have one pair of quotes to much. Use the following instead:

Where CustomFieldName = '$(vCustomFieldName)';

HIC