topic Re: Two different tables data in QlikView

Two different tables data

Sra1bandi — Wed, 21 Dec 2022 04:20:38 GMT

Table 1:-

id status1

1 Error

2 completed

3 Errore

4 Cancelled

Table 2:-

id status2

1 Cancelled

2 completed

3 Cancelled

4 completed

This is already developed app by someone now we got new requirement i.e,

When the Status1 from table1 shows===> "Error" in table2==> status2 also need to show as==> "Error". Id is the common field for both tables so many fields are there in two tables but Id is primary key and status field needs to change as above mentioned.

both are different tables not joined in backend how i need to show Status2 as Error when status1 shows Error

Regards,

Sra1.

Re: Two different tables data

BrunPierre — Wed, 21 Dec 2022 18:41:15 GMT

Table1: Mapping LOAD * Inline[ ID,STATUS1 1,Error 2,Completed 3,Error 4,Cancelled ] Where Match(STATUS1,'Error'); Table2: LOAD *, ApplyMap('Table1',ID,STATUS2) as STATUS Inline[ ID,STATUS2 1,Cancelled 2,Completed 3,Cancelled 4,Completed ]; DROP Field STATUS2; RENAME Field STATUS to STATUS2; EXIT SCRIPT;

Re: Two different tables data

Sra1bandi — Wed, 21 Dec 2022 17:05:54 GMT

There are so many ID's which are errors not single id

Re: Two different tables data

BrunPierre — Wed, 21 Dec 2022 18:55:02 GMT

Hi @Sra1bandi

Try again with the above modified script. Values of Status2 are retained when there is no match.