Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining files

I have 2 csv files. One contains headers to the other file data. How do I combine both the files into a single QVD in Qlikview?

11 Replies
its_anandrjs

Please elaborate more what is means by headers.

Did this means one file has headers and other on is Item.

Regards

Anand

Not applicable
Author

Headers means Column names.

Not applicable
Author

You have 2 files one file have the headers and one file have the underline data, now you want show the both headers and underline data. am i correct..?

Not applicable
Author

Yes.

Not applicable
Author

Hey Plz look into the attachments...!

Anonymous
Not applicable
Author

If one file contains only the headers to the other files and the other file contains the data, then you can use simple concatenate option by the method of renaming where you can load all the data from CSV and rename both in the same name which will cause data to concatenate and can be fetched into a new QVD.

In case of an more complex problem, Please ellaborate more or post some samples so that we can understand better.

-Vigneshwaran M K

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

If u have all columns are same in both the files, use Concatinate or use join.

I hope this might helps you..

-Nagarjun

Anonymous
Not applicable
Author

Use concanate or Join . Both will work

MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_239139_Pic1.JPG

tabHeaders:

CrossTable (ColNam, ColVal)

LOAD 1, * Inline [

FirstColumn, AnotherColumn, SomeDifferentColumn, LastColumn

] (no labels);

mapHeaders:

Mapping LOAD ColNam, ColVal Resident tabHeaders;

DROP Table tabHeaders;

tabData:

LOAD * Inline [

A, B, C, D

E, F, G, H

I, J, K, L

] (no labels);

RENAME Fields using mapHeaders;

(replace inline loads with your csv loads)

hope this helps

regards

Marco