Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
table1:
Load
*
from file1;
Concatenate (table1)
Load
*
from file2;
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
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;
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;
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 .