Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please elaborate more what is means by headers.
Did this means one file has headers and other on is Item.
Regards
Anand
Headers means Column names.
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..?
Yes.
Hey Plz look into the attachments...!
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
Hi,
If u have all columns are same in both the files, use Concatinate or use join.
I hope this might helps you..
-Nagarjun
Use concanate or Join . Both will work
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