Field not found

[xyz2]

Hi,

I am trying to load my csv file via data editor in Qlik.

I have an table with two columns "Team" and "Value" for that i did:

[MyTable]:

LOAD
    Team as [Team],
    Value as [Value]
    FROM [lib://x/x\x\x\myTable.csv]
(txt, codepage is 28591, embedded labels, delimiter is ';', no quotes);

Qlik loads Value, but for Team i get an error "Field 'Team' not found". There is no further information, why it can't be found.

I already checked the column names, but it still doesn't load Team.

Does anyone have an idea how i can solve this problem?

[R_Mendoza · Accepted solution]

Hello @xyz2,

you problem is here.

delimiter is ';'

Change it to ' , ' . maybe in the csv it is separated by ' , '.

CSV:

[MyTable]:
LOAD
Team,
Value
FROM [lib://...../Test.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

 Best regards,

Renzo

[xyz2]

That was pretty much what i needed. Thank you!