Odd syntax error in load script

[#1]

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]

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

[#3]

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]

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]

Hi Aaron

from Your attachment

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

Resident Fact;

[sunny_talwar]

Here you go...

[#7]

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 · Accepted solution]

Try the attached

[#9]

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

[#10]

Thanks