topic Re: Syntax error, missing/misplaced FROM error in QlikView

Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 16:55:44 GMT

Trying to create a qvd from a .dat file.

I am using a template that has worked before, and changed the file names and field names to the ones I need for this project.

However, I get the error.

Any help is appreciated

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 17:06:10 GMT

May be try running the script removing semicolon ; near then statement.

IF ........ then

.........

........

ENDIF

And can you try running this in Debug Mode and see where it is throwing error?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 18:07:35 GMT

No, that didn't fix the issue.

In debug mode, the reload stops right after the 4th "Let vName4 = FieldValue('Name4',1);"

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 18:35:15 GMT

Can you comment the 4th LET and run and check?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 18:38:48 GMT

Commenting out the fourth Let doesn't help.

The debugger actually stops at the line that says Fact2:

but the vName's are highlighted red when the debugger goes through them

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 19:10:54 GMT

Can you use quotes around those variables like:

Data1 AS '$(vName)',

Date2 AS '$(vName)',

.....

Can you check this ?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 19:32:13 GMT

It managed to reload, but now there are no available fields...

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 19:58:40 GMT

What you mean, nothing loaded? Did you debug? Is that your full script?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 20:03:10 GMT

Yes. I reloaded it and it worked, but I don't think that is the correct way to fix this issue.

After it reloaded, there were no fields. Yes that is my full script. I did debug, and it got caught right after Let vName4 and when it got to Fact2 it stopped. After putting quotes around them like you said, it reloaded, but no fields were loaded, it was just all blank.

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 20:24:29 GMT

Hmm Strange. I am not sure what is happening? Can you reload only the data until LET commands and see if those variables holding any data using Ctrl+Alt+V and check the variable values?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 20:26:38 GMT

This is what I get. I commented out everything starting from the LET and to the end of the script.

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 20:49:33 GMT

Do you have data in your Payment_Sources.qvd?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 20:52:12 GMT

As of now, no. All that is in that qvd is just the table headers, because this QVW goal is to create this qvd. When I open the qvd as it is now, the tables are in there, like full_amount,etc. but there is no data. Is this an issue?

Re: Syntax error, missing/misplaced FROM error

Thu, 15 Jun 2017 20:56:00 GMT

I just added a line of test data into each of the four fields, so now the qvd has data in it. I then tried running it again, but still got the same error

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Thu, 15 Jun 2017 21:33:58 GMT

Can you send me your qvw file with that test data please if possible?

Re: Syntax error, missing/misplaced FROM error

Fri, 16 Jun 2017 13:49:25 GMT

Here, I have attached the QVW and some test data

Re: Syntax error, missing/misplaced FROM error

Fri, 16 Jun 2017 14:55:45 GMT

Here is the error for reference

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Fri, 16 Jun 2017 16:25:01 GMT

Sure will look into it.

Re: Syntax error, missing/misplaced FROM error

Fri, 16 Jun 2017 16:26:41 GMT

Actually, I got it figured out now. The method of putting quotes/brackets around those variables worked, but now I have two tables of each table.

However, thank you a lot for your previous help.

Re: Syntax error, missing/misplaced FROM error

vishsaggi — Fri, 16 Jun 2017 16:30:47 GMT

Check your data model? Pressing Ctrl+T