custom filed associate

[#1]

I'm a newbie on qlikview. I have search around in google and not found the answer.

In my case， there are the table for example.

tableA：

    field_n, field_a

tableX：

    field_n, field_x

tableY：

    field_n, field_y

On the other hand, not all value that in the tableA.field_n exist in the tableX.field_n or tableY.field_n.

I want to associate file_n between tableA and tableX， tableA and tableY, but not tableX and tableY,

and I need a list table with tableA， to filter record in tableX and tableY.

After try with mapping and alias filed_n with different field name, then I have no any idea. 

Thanks for any help.

[agomes1971]

Hi,

sorry I think is easier to do like this:

TableA：

    field_n, field_a;

concatenate

TableX：

    field_n, field_x

conacatenate

TableY：

    field_n, field_y

and then make a list.

HTH

André Gomes

[sunny_talwar · Accepted solution]

Not 100% sure, but may be something like this:

tableA:

LOAD field_n,

           field_a,

           field_n as field_AX,

           field_n as field_AY

tableX:

LOAD field_n,

           field_x,

           field_n as field_AX

tableY:

LOAD field_n,

           field_y,

           field_n as field_AY

[#4]

Thanks at first.But I can not change the table layout with some reason.