topic Re: Dynamic 'as' in Load in QlikView

Dynamic 'as' in Load

Fri, 27 Sep 2013 10:33:56 GMT

Hi!

I'm using Section Access and I would like to be able to dynamically change the "as ..." part depending on if the user has the three first digits in Access set to 'LFC' or not.

LOAD
     Trim(ROLL) as ROLL,
     USER,
     if((match(mid(Access,1,3),'LFC')),Access as [Fomr(T)],Access as Kluster)

FROM

Is this even possible?

Regards Johan

Re: Dynamic 'as' in Load

Anonymous — Fri, 27 Sep 2013 13:43:55 GMT

Johan,

You can use this:

LOAD
     Trim(ROLL) as ROLL,
     USER,
     Access as [Fomr(T)]
FROM...
WHERE match(mid(Access,1,3),'LFC')

CONCATENATE LOAD
     Trim(ROLL) as ROLL,
     USER,
     Access as Kluster
FROM...
WHERE match(mid(Access,1,3),'LFC')=0

Regards,
Michael

Re: Dynamic 'as' in Load

marcus_sommer — Fri, 27 Sep 2013 14:32:41 GMT

Generally you could a field named with a variable dynamically, but it meant always only one field at the time and not two fields. I think you should rather create two separate fields and react later in your script/expressions appropriate.

- Marcus