Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam trying to load this data, but I am getting error, Can you please give me a suggestion, Any mistake in this Script::
Table1:
LOAD *FROM INLINE [
Resource, sector
Janet P, Team1
David J, Team2
Peter N, Team1
Sarah P, Team1
Michael H, Team2
];
Table2:
LOAD *FROM INLINE [
Resource, Salary, Sales
Sarah P, £33,000, £150,000
Donald T, £24,000, £147,000
Janet P, £27,000, £72,000
Walter M, £26,000, £107,000
David J, £32,000, £96,000
Peter N, £29,000, £47,000
Donny G, £31,000, £112,000
Michael H, £28,000, £137,000
Trisha Y, £32,000, £92,000
Derek A, £33,000, £63,000
];Table1:
LOAD *FROM INLINE [
Resource, sector
Janet P, Team1
David J, Team2
Peter N, Team1
Sarah P, Team1
Michael H, Team2
];
Table2:
LOAD *FROM INLINE [
Resource, Salary, Sales
Sarah P, £33,000, £150,000
Donald T, £24,000, £147,000
Janet P, £27,000, £72,000
Walter M, £26,000, £107,000
David J, £32,000, £96,000
Peter N, £29,000, £47,000
Donny G, £31,000, £112,000
Michael H, £28,000, £137,000
Trisha Y, £32,000, £92,000
Derek A, £33,000, £63,000
];
Hi
Remove your FROM in all of the inline table.
It's just LOAD * INLINE
not LOAD * FROM INLINE
Many Thanks
Karthik