topic column header replace in QlikView

column header replace

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have tried each n every technique to replace the dynamic column header name but all work gone in vain.

PFA

sunny_talwar — Mon, 05 Mar 2018 12:00:55 GMT

I am not entirely sure I understand... are you going to ever only bring one Mem_id or was that an example?

Karim_Khan — Mon, 05 Mar 2018 12:10:45 GMT

That was an example i have tried to implement the things from your previous posts logic but its not working.

in my current scenario if I will take one member ID it contains more than one value

e.g

if MEM_ID 9211 it can contain EMP_ID at E_01

and if will take other MEM_ID it can contain Emp_DOB at E_01

Looping the code

for i=1 to NoOfRows('Table')

let vName$(i)=Peek('A',i-1,'Table');

next i;

LOAD

MEM_ID AS '$(vName1)',

...

But this code will work only if that MEM_ID holds one record per row in my scenrio it is holding multiple records