Syntax error, missing/misplaced FROM error

[#1]

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

[#2]

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

[vishsaggi]

Do you have data in your Payment_Sources.qvd?

[#4]

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?

[#5]

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

[vishsaggi]

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

[#7]

Here, I have attached the QVW and some test data

[#8]

Here is the error for reference

[vishsaggi]

Sure will look into it.

[#10]

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.

[vishsaggi]

Check your data model? Pressing Ctrl+T