Qlikview script

wengeler — Wed, 24 Oct 2018 06:55:47 GMT

Hello,

I have :

- an 'A' file with

a KPNR (Key) field: nr of commands

a KPSP field: which contains '1' when in this command is a cup.

- a file 'B' with

a PSNR (Key) field: nr of commands

a PSPO field: Positions

a PSAR field: nr of the article

a PSDE field: designation of the article

I would like help to write a script that reads the file 'A' and when the KPSP field contains 1, it lists all the commands and all the positions of the file 'B' associated, in a file 'C'.

Said like that it looks like it's easy but whatever the load resident I do (inner, left, right, inner etc ...), I always find myself with a single line of my table 'B' in my table 'C' (that of course that contains '1') but I would like to see all the positions and items of the order that contains '1'. (if the order contains a cup ('A') which positions of the file 'B' are associated with this command?

(Did the customer buy the saucer and dessert plate that go with this cup?)

Thank you in advance for your help.

Cordially

Re: Qlikview script

dplr-rn — Wed, 24 Oct 2018 18:40:21 GMT

can you share sample data and desired output

topic Re: Qlikview script in QlikView

Qlikview script

Re: Qlikview script