Discussion Board for collaboration on QlikView Scripting.
I have looked through every single syntax error post in the forum, and I don't think my issue is the same as any of them.
I wrote this script based on a template that works, and just changed file names and headers. It should work but it doesn't
I have attached the sample data.
Any help is appreciated.
Go to Solution.
Try the attached
The new names you are assigning have spaces in them... you need to cover them with  or ""
still results in same error. I have _, not spaces in my code, im not sure why the script error shows it as spaces
Data1 as [$(vName1)],
Data2 as [$(vName2)],
Data3 as [$(vName3)],
Data4 as [$(vName4)]
These variables are created using data from cutoffar.dat and not the inline table
from Your attachment
Fact2: Load Data1 as $(vName1), Data2 as $(vName2), Data3 as $(vName3), Data4 as $(vName4) Resident Fact;
Here you go...
Thank you, one more issue however.
Now I have double the amount of tables.
I think putting the 4 things in [ ] resulted in it making 2 separate tables.
Any idea how to fix this?
Ah yes thank you. For some reason the template I was working off of, the script code worked for them. But thank you this solves my problem