HELP in a qlikview statement

[#1]

Hi.

I have two tables TABLE1 and TABLE2 as presented in the attached file.

I want to write a qlikview script to construct the TABLE3 always as presented in the attached file.

NB:

Look at the semantic between the fields DEBCPTE and FINCPTE of table FORMULE and field NUMCPT of table ECRITURE.

The field IDFORMULE of the table FORMULE must migrate into the newer created table.

Thanks.

[brenner_martina]

??? where is the file ????

[brenner_martina]

Hi Gael,

pardon, what has to match together?

DEBCPTE & FINCPTE with a part of NUMCPT?

or do you mean intervalmatch?

[#4]

Martina wrote:
Hi Gael,
pardon, what has to match together?
DEBCPTE & FINCPTE with a part of NUMCPT?
or do you mean intervalmatch?<div></div>

Yes DEBCPTE and FINCPTE are the bounds of interval and also the part of NUMCPT.

OK

[brenner_martina]

OK, so you have to seperat the first to numbers of NUMCPT:

Left(NUMCPT,2) As NUMCPTKey

then use the function intervalmatch from your first table with start DEBCPTE and End FINCPTE

[#6]

Martina wrote:
OK, so you have to seperat the first to numbers of NUMCPT:
Left(NUMCPT,2) As NUMCPTKey
then use the function intervalmatch from your first table with start DEBCPTE and End FINCPTE<div></div>

Please Martina, can you do an example?

Please look at the attached file.

Thanks.

[#7]

PFA.

[#8]

Please Srinivasan.

Have you looked at the structure of TABLE3 in the attached file LIST_OF_TABLE.doc?
I can not find the field IDFORMULE, yet it is most important.
Thank you.