Re: Table1: - Qlik Community

Kohli · ‎2018-02-12

Iam trying to load this data, but I am getting error, Can you please give me a suggestion, Any mistake in this Script::

Table1:

2

LOAD *FROM INLINE [

3

4

Resource, sector

5

6

Janet P, Team1

7

David J, Team2

8

Peter N, Team1

9

Sarah P, Team1

10

Michael H, Team2

11

12

];

13

14

Table2:

15

16

LOAD *FROM INLINE [

17

18

19

Resource, Salary, Sales

20

21

Sarah P, £33,000, £150,000

22

Donald T, £24,000, £147,000

23

Janet P, £27,000, £72,000

24

Walter M, £26,000, £107,000

25

David J, £32,000, £96,000

26

Peter N, £29,000, £47,000

27

Donny G, £31,000, £112,000

28

Michael H, £28,000, £137,000

29

Trisha Y, £32,000, £92,000

30

Derek A, £33,000, £63,000

31

];
Table1:

2

LOAD *FROM INLINE [

3

4

Resource, sector

5

6

Janet P, Team1

7

David J, Team2

8

Peter N, Team1

9

Sarah P, Team1

10

Michael H, Team2

11

12

];

13

14

Table2:

15

16

LOAD *FROM INLINE [

17

18

19

Resource, Salary, Sales

20

21

Sarah P, £33,000, £150,000

22

Donald T, £24,000, £147,000

23

Janet P, £27,000, £72,000

24

Walter M, £26,000, £107,000

25

David J, £32,000, £96,000

26

Peter N, £29,000, £47,000

27

Donny G, £31,000, £112,000

28

Michael H, £28,000, £137,000

29

Trisha Y, £32,000, £92,000

30

Derek A, £33,000, £63,000

31

];

karthikoffi27se · ‎2018-02-12

Hi

Remove your FROM in all of the inline table.

It's just LOAD * INLINE

not LOAD * FROM INLINE

Many Thanks

Karthik