Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have one pair of quotes to much. Use the following instead:
Where CustomFieldName = '$(vCustomFieldName)';
HIC
You have one pair of quotes to much. Use the following instead:
Where CustomFieldName = '$(vCustomFieldName)';
HIC