Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SubField() function

Hi,

This function just doesnt seem to work. I have tried loading the data with the lib path and disabling the standard mode.

Any help will be greatly appreciated!

-ThanksScreenshot (28).pngScreenshot (29).png

6 Replies
sunny_talwar

I don't think this has to do with the SubField function because you are erroring out at the top of the table for ProductID... I think you will see the same error if you don't add SubField... it seems to be something related to the location of the file

vvira1316
Specialist II
Specialist II

Your file is missing ProductID field. Error is not for Subfield function. Please check

Anonymous
Not applicable
Author

Thanks for your response.

But my access table does contain ProductID field!

I tried loading it again, but it doesnt seem to recognize the fields!

PFAScreenshot (30).pngScreenshot (31).png

Anonymous
Not applicable
Author

PFB!!

-Thanks,

vvira1316
Specialist II
Specialist II

Check spelling/case for the field. May be some typos

Probably path issue...

Is there a reason for doing it separately. Try putting it in the first load and comment out everything related to path to see if path is causing it to fail.

Anonymous
Not applicable
Author

Any leads on this?