topic Re: Odd syntax error in load script in QlikView

Odd syntax error in load script

Fri, 16 Jun 2017 15:58:35 GMT

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.

sunny_talwar — Fri, 16 Jun 2017 16:03:36 GMT

The new names you are assigning have spaces in them... you need to cover them with [] or ""

Fri, 16 Jun 2017 16:07:23 GMT

still results in same error. I have _, not spaces in my code, im not sure why the script error shows it as spaces

sunny_talwar — Fri, 16 Jun 2017 16:11:27 GMT

Try this

Fact2:

Load

Data1 as [$(vName1)],

Data2 as [$(vName2)],

Data3 as [$(vName3)],

Data4 as [$(vName4)]

Resident Fact;

These variables are created using data from cutoffar.dat and not the inline table

antoniotiman — Fri, 16 Jun 2017 16:11:41 GMT

Hi Aaron

from Your attachment

Fact2:
Load
Data1 as $(vName1),
Data2 as $(vName2),
Data3 as $(vName3),
Data4 as $(vName4)

Resident Fact;

sunny_talwar — Fri, 16 Jun 2017 16:13:01 GMT

Here you go...

Fri, 16 Jun 2017 16:20:54 GMT

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?

sunny_talwar — Fri, 16 Jun 2017 16:22:37 GMT

Try the attached

Fri, 16 Jun 2017 16:30:29 GMT

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

Fri, 16 Jun 2017 16:30:38 GMT

Thanks