topic Re: How to get data easily into excel file? in QlikView

How to get data easily into excel file?

Thu, 26 Jun 2014 15:34:39 GMT

Hi,

I have a table in qvw with 30,000 records and the table have data CustomerID, phone numbers of the customers. I have another excel file with 50 CustomerIDs and these 50 are in qvw table. I need to get phone numbers for these 50. How can I get easily without doing manual work. can anyone suggest me is there any way please? I tried using inline table but it seems not working.

Thanks.

Re: How to get data easily into excel file?

Brice-SACCUCCI — Thu, 26 Jun 2014 15:48:01 GMT

Hello,

you just have to load both files in QlikView. If both files contain a "CustomerID" column, QlikView will associate the data for you.

Re: How to get data easily into excel file?

Anonymous — Thu, 26 Jun 2014 15:53:20 GMT

It is easy.

Let's call the customer table you have now Customer, and it has a field CustomerID. Add this script:
Customer2:
LOAD

CustomerID,

CustomerID as CustomerID2

FROM <your file>;

On the front end, create a table box with the fields CustomerID2 and Phone. Suppress null values for the CustomerID2. Export the result to Excel.

Re: How to get data easily into excel file?

Tue, 01 Jul 2014 07:52:57 GMT

Thanks.