Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

5 Replies
Highlighted
MVP
MVP

Re: Merge two csv files with the help of QV

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?

Highlighted
Not applicable

Re: Merge two csv files with the help of QV

If possible could you post an example application?

Highlighted
Champion III
Champion III

Re: Merge two csv files with the help of QV

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;

Highlighted
Employee
Employee

Re: Merge two csv files with the help of QV

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)

Highlighted
Partner
Partner

Re: Merge two csv files with the help of QV

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!!