topic Re: Combining files in QlikView

Combining files

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Combining files

its_anandrjs — Wed, 09 Nov 2016 09:48:59 GMT

Please elaborate more what is means by headers.

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

Regards

Anand

Re: Combining files

Wed, 09 Nov 2016 09:54:58 GMT

Headers means Column names.

Re: Combining files

Wed, 09 Nov 2016 10:22:06 GMT

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..?

Re: Combining files

Wed, 09 Nov 2016 10:23:08 GMT

Yes.

Re: Combining files

Wed, 09 Nov 2016 10:25:24 GMT

Hey Plz look into the attachments...!

Re: Combining files

Anonymous — Wed, 09 Nov 2016 10:38:46 GMT

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

Re: Combining files

nagarjuna_kotha — Wed, 09 Nov 2016 10:42:08 GMT

Hi,

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

I hope this might helps you..

-Nagarjun

Re: Combining files

Anonymous — Wed, 09 Nov 2016 10:53:58 GMT

Use concanate or Join . Both will work

Re: Combining files

MarcoWedel — Wed, 09 Nov 2016 22:07:22 GMT

Hi,

maybe one solution could be:

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

Re: Combining files

Thu, 10 Nov 2016 04:10:40 GMT

Hi this resolved my issue.

Thanks

Re: Combining files

MarcoWedel — Thu, 10 Nov 2016 22:13:27 GMT

Hi,

another example (using arumamahesh's sample data) without the need to manually define column names as aliases in the script (thus rendering the header table useless):

tabHeaders:
CrossTable (ColNam, ColVal)
LOAD 1, * From [https://community.qlik.com/servlet/JiveServlet/download/1156762-252995/Sample.xlsx] (ooxml, no labels, table is Sheet1);

mapHeaders:
Mapping LOAD ColNam, ColVal Resident tabHeaders;

DROP Table tabHeaders;

tabData:
LOAD * From [https://community.qlik.com/servlet/JiveServlet/download/1156762-252995/Sample.xlsx] (ooxml, no labels, table is Sheet2);

RENAME Fields using mapHeaders;

hope this helps

regards

Marco