topic Re: Reverse Row Value for ID in QlikView

Reverse Row Value for ID

erric3210 — Fri, 15 Nov 2024 23:49:45 GMT

Hi All,

I've ID and against that there is one flag which has 1 & 2 values. I want 2nd value for 1st flag and 1st value for 2nd flag.

Is there any simple code for this.

This is my requirement:

For reference, below is the Inline Code:

LOAD * INLINE [
ID, Group_Name, Flag_New, Amount
"Test_Code1", AAA, 1, 40000
"Test_Code1", BBB, 2, 55000
"Test_Code2", CCC, 1, 88000
"Test_Code2", DDD, 2, 91000
"Test_Code3", EEE, 1, 62000
"Test_Code3", FFF, 2, 20000
];

Regards,

Eric

Re: Reverse Row Value for ID

Taoufiq_Zarra — Mon, 12 Oct 2020 07:51:34 GMT

@erric3210 One Option :

Data: LOAD * INLINE [ ID, Group_Name, Flag_New, Amount "Test_Code1", AAA, 1, 40000 "Test_Code1", BBB, 2, 55000 "Test_Code2", CCC, 1, 88000 "Test_Code2", DDD, 2, 91000 "Test_Code3", EEE, 1, 62000 "Test_Code3", FFF, 2, 20000 ]; left join load pick(Match(Flag_New,'1','2'),'2','1') as Flag_New,ID,Amount as Desired_output resident Data;

output:

Re: Reverse Row Value for ID

erric3210 — Mon, 12 Oct 2020 15:27:50 GMT

Hi Taoufiq ZARRA,

Thanks for the Solution. It worked.

Regards,

Eric