I have a number of CSV files to load into Qlikview but unfortunately in the CSV files I have two fields with the same name: 'Description', but I only want to load the first column called 'Description'.
When I use the loading wizard (via Script Editor - Table Files) the script calls one 'Description' and the other 'Description1', but when I try to run it by commenting out 'Description1' it is loading the wrong 'Description' column (effectively loading the 'Description1' column).
Plus, when I don't comment out 'Description1' to load both columns it comes up with an error as that field does not exist.
please try with this piece of code for the example you have attached:
LOAD [Account Name],
[Customer Address 1],
[Post Code],
[Document Date],
Description,
[Pack Size],
[Line Qty]
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(
Remove(Col, Pos(Top, 7))
));
The key point seems to be the remove sentence. I have run the transformation step in the wizard and removed the second "Description" column, which is in position 7.
could you please upload a sample of those CSV files (it does not need to be real data but at least they should keep the "Description" fields), so we can check them?
if I understand you right, you want to have the field "Description" from the 1st table selectable also for the 2nd table instead of its own field "Description", right?
For that to work, you'll have to join that field from table_1 to table_2 - so you have to load table_1 first:
I've uploaded a CSV file in the original post. The 'Description' field occurs twice in the CSV. I want to load all data other than the second 'Description' field.
This is an edited CSV, there are about 30 fields in the original so I didn't really want to upload the data using @1,@2 as field names, but if needs be I can...
please try with this piece of code for the example you have attached:
LOAD [Account Name],
[Customer Address 1],
[Post Code],
[Document Date],
Description,
[Pack Size],
[Line Qty]
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(
Remove(Col, Pos(Top, 7))
));
The key point seems to be the remove sentence. I have run the transformation step in the wizard and removed the second "Description" column, which is in position 7.
Many thanks for all your responses. I'll go with the response from Salto as that keeps my field names and I think Drop Field may cause an issue as when I've tried to load data and Qlikview has called the second column 'Description1', then tried to reload them, it hasn't worked as 'Description1' doesn't exist.
