Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Thanks at first.But I can not change the table layout with some reason.