topic Re: Qualify without dot in QlikView

Qualify without dot

Anonymous — Thu, 11 Aug 2016 08:50:24 GMT

Hi,

I want to use Qualify and UnQualify for the tables but i dont want to represent it as tablename.columnname

I just want tablenamecolumnname

could you please suggest me

Re: Qualify without dot

marcus_sommer — Thu, 11 Aug 2016 08:58:51 GMT

AFAIK this couldn't customized but you could after the qualifying rename these fields.

- Marcus

Re: Qualify without dot

Anonymous — Thu, 11 Aug 2016 09:10:10 GMT

if i could rename the fields i wouldnot go for Qualify option.

I will straight away use aliasing.

Re: Qualify without dot

Mark_Little — Thu, 11 Aug 2016 09:15:53 GMT

HI John,

That is how Qualify works, if you not want to do that when then an options maybe to look at using friendly names,

How to Rename Fields

Mark

Re: Qualify without dot

sunny_talwar — Thu, 11 Aug 2016 10:11:58 GMT

We see your point, but I guess that is how QlikView's Qualify work and I don't think there is a way to change the default settings as Marcus already mentioned

Re: Qualify without dot

petter — Thu, 11 Aug 2016 11:02:09 GMT

You can achieve your requirements with a little bit of code without having to manually rename each field:

QUALIFY *;
Data:
LOAD
  *
FROM
    ......;


FOR i=1 TO NoOfFields('Data')
  fn = FieldName(i,'Data');
  TRACE Field# $(i) = '$(fn)';
  newfn = 'Data' & SubField(fn,'.',2);
  RENAME FIELD [$(fn)] TO [$(newfn)];
NEXT

I showed this for a single table but you can also do it for multiple tables by having an extra FOR ... NEXT loop wrapping the FOR ... NEXT for each field...

nt = NoOfTables();
FOR t=1 TO $(nt)
  tn = TableName(t-1);
  FOR i=1 TO NoOfFields(tn)
  fn = FieldName(i,tn);
  newfn = tn & SubField(fn,'.',2);
  TRACE Field# $(i) = [$(fn)] will be renamed to [$(newfn)] ;
  RENAME FIELD [$(fn)] TO [$(newfn)];
  NEXT
NEXT

Re: Qualify without dot

rubenmarin — Thu, 11 Aug 2016 11:21:47 GMT

Nice code. I want only comment that in case table names contains dots newfn can be created like:

newfn = tn & Mid(fn, Len(tn) +2);