topic Re: Combining data from two files into one table in QlikView

Combining data from two files into one table

stekol61 — Thu, 06 Apr 2017 14:15:40 GMT

Hi!

I'm trying to load data from two files and combine tthe result into one file.

I can load the data from the two files to the tables: temp1 and temp2. and i want all data to be available in temp3.

What is the best way to do this?

Enclosed is my report and the two files

/Stefan

Re: Combining data from two files into one table

jrepucci15 — Thu, 06 Apr 2017 14:18:21 GMT

table1:

Load

from file1;

Concatenate (table1)

Load

from file2;

Re: Combining data from two files into one table

stekol61 — Fri, 07 Apr 2017 07:58:16 GMT

Hi!

The problem with this is that the data from the two files are stored on separate rows.

For each date I need the data from both tables to be in one row

Re: Combining data from two files into one table

tamilarasu — Fri, 07 Apr 2017 08:13:49 GMT

Hi Stefan,

temp1:
LOAD Time,
[Answered Calls],
[Call Drop Rate (%) - Core],
[Call Drop Rate (%) - Radio],
[Call Drop Rate (%) - User]
FROM
[Call Answered and DR per Release Cat.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
store temp1 into C:\Temp\temp1.qvd;

Left Join (temp1)
temp2:
LOAD Time,
[Call Attempts],
[Call Inefficiency (%) - Core],
[Call Inefficiency (%) - Radio],
[Call Inefficiency (%) - User]
FROM
[Call Attempts and Ineff by Release Cat.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
store temp2 into C:\Temp\temp2.qvd;

Re: Combining data from two files into one table

stekol61 — Fri, 07 Apr 2017 08:48:13 GMT

Ok. That works.

What if I also want to joad date from a third file. Should I then just add a new Join statement?

temp3:

LOAD Time,,

[Attach FR (%)] as [Attach FR-MME (%)],

[Attach Failed] as [Attach Failed-MME]

FROM

[Attach.csv]

(txt, utf8, embedded labels, delimiter is ',', msq, no eof);

store temp3 into C:\Temp\temp3.qvd;

Re: Combining data from two files into one table

tamilarasu — Fri, 07 Apr 2017 08:54:49 GMT

Yes. You have to create another left join for new file. I would suggest you read the below link for better understanding of joins and concatenate function .

Understanding Join, Keep and Concatenate