Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Can you try this:

Qualify *;

GLAccountNo:

LOAD *;

SQL SELECT *

FROM dbo.vGL2LvlAcctDataByA;

UNQUALIFY *;

View solution in original post

5 Replies
sunny_talwar

Can you try this:

Qualify *;

GLAccountNo:

LOAD *;

SQL SELECT *

FROM dbo.vGL2LvlAcctDataByA;

UNQUALIFY *;

Not applicable
Author

Can this be done with a crosstable load?

sunny_talwar

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
Author

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
Author

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.