Cross qvd With xlsx

[coddra_6]

Hey!!

What's Up? I want to know How can I cross a dimention (qvd) with a Excel File (xlsx).

I have the case:

Client Dimention:
     Client Code
     Cliente Name
     Cliente Product Code

Excel File:
     Product Code
     Product Name
     Product Risk

And I whant a dimention called Analysis:

Analysis:
     Cliente Code
     Product Code
     Product Risk

But I don't know how to get it.

Hope your help!!

Thanks!!

[MayilVahanan]

HI

Join with excel and qvd

Try like this

Client:

Load

ClientCode,

     ClienteName,

     ClienteProductCode

from client.qvd(qvd);

Left join(Client)

Load

      ProductCode as [ClienteProductCode],

     ProductName,

     ProductRisk

From product.xlsx;

[Clever_Anjos]

"Cliente Product Code" and "Product Code" have the same values (can be a key)?

If so,just rename

LOAD

*,

Product Code as liente Product Code

from yourexcelfile;

AQL will handle the rest

[coddra_6]

Yeah, but I need to use:

WHERE Cliente Country = 'Germany'

And the Cliente Country is in the Dimention Cliente.

[Oleg_Troyansky]

You will need to join the tables first, and then reload using a RESIDENT load, to only filter Clients from Germany.

[#6]

Hi,

Try like this

Client:

Load

ClientCode,

     ClienteName,

     ClienteProductCode

from client.qvd(qvd);

Left join(Client)

Load

      ProductCode as [ClienteProductCode],

     ProductName,

     ProductRisk

From product.xlsx;

Analysis:

Load

Cliente Code,

     Product Code,

     Product Risk,

Resident Client

where dim='dim Value';