Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Rename data in load for ease of reading

Greetings,

I am loading SQL Statements in my script. the from clause is like FROM dbo.vGL2LvlAcctDataByA.  Qualified it produces a field like vGL2LvlAcctDataByA.AccountNo.  How can I get it to look like GLAccounts.AccountNo via the load script without changing the name of my view in SQL?

Thanks,

Frank

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Rename data in load for ease of reading

Can you try this:

Qualify *;

GLAccountNo:

LOAD *;

SQL SELECT *

FROM dbo.vGL2LvlAcctDataByA;

UNQUALIFY *;

5 Replies
sunny_talwar
Not applicable

Re: Rename data in load for ease of reading

Can you try this:

Qualify *;

GLAccountNo:

LOAD *;

SQL SELECT *

FROM dbo.vGL2LvlAcctDataByA;

UNQUALIFY *;

Not applicable

Re: Rename data in load for ease of reading

Can this be done with a crosstable load?

sunny_talwar
Not applicable

Re: Rename data in load for ease of reading

Frank -

I believe this should work with the CrossTable Load. Is it not working? I would suggest giving it a try and come back if it did not work for some reason.

Best,

Sunny

Not applicable

Re: Rename data in load for ease of reading

Sunny,

I am getting fields from the load.  I have My_Data.AorB and My_Data.My_Data.AorB. This is Happening to [AorB], [Product], [Year] and GL_Account

Here is what I have so far.

My_Data:

Crosstable(NamedMonth, MonthData,11)

SQL Select [Hierarchy1Link]

,[Product]

,[Hierarchy2Link]

,[Year]

,[AorB]

,[GL_Account]

,[Link1]

,[Link2]

,[Link3]

,[Link4]

Hierarchy3Link]

,[Jan]

...

[Dec]

Not applicable

Re: Rename data in load for ease of reading

Greetings,

As far as the Cross Table went, I used a SQL View with a pivot. Basically I solved my own problem on that part.