

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Merge two csv files with the help of QV
Hello Experts,
I have two csv files. lets say Test_1.csv , Test_2.csv.
Test_1.csv file contains 260 columns (Fields) ( out of 260 fileds 60 fields has no data (these days comes from Test_2.csv file)), Test_2.csv has 63 columns. But both has the First 3 columns are same. Now I want to generate/Create a Final_Output.csv file with 260 columns.
Note: When I load both Files into QV, since many fields are same, QV getting hanged. So not sure how to resolve this issue.
Please help me.
Thanks in advance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you could share more about the internal structure and column names of the two CSV-files we could make better suggestions for you.
The 60 fields that have no data are they repeating columns, they contain numbers I guess?
What are the three first columns? Names and meaning?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If possible could you post an example application?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try next:
Table:
LOAD
field1,
field2,
field3,
...
Field200
// do not load these empty 60 columns
FROM Test_1.csv;
LEFT JOIN (Table) LOAD
field1,
field2,
field3,
field4 as field 201,
...
field63 as feild 260
FROM Test_2.csv;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qualify *;
Unqualify field1, field2, field3;
LOAD
field1,
field2,
field3,
.... other fields
From file1.csv(txt);
LOAD
field1,
field2,
field3,
.... other fields
From file2.csv(txt)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Experts,
Sorry for the delay in response,
Here I am attaching the Model csv files. I want tlo merger ABC_Data_1.csv , XYZ_Data_1.csv files and Output file should be similar to ABC_XYZ_Data_Output.csv. Here Custoer_ID, ID, Partner_ID are Keyfield in between two csv files. I want to merger fields from XYZ_data_1.csv to ABC_Data_1.csv file.
Please help!!
