column header replace

[Karim_Khan]

Hi All,

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

PFA

stalwar1‌

[sunny_talwar]

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

[Karim_Khan]

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;

B:

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