Combining data from two files into one table

[stekol61]

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

[jrepucci15]

table1:

Load

*

from file1;

Concatenate (table1)

Load

*

from file2;

[stekol61]

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

[tamilarasu]

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;

[stekol61]

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;

[tamilarasu]

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