Rename data in load for ease of reading

[#1]

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

[sunny_talwar · Accepted solution]

Can you try this:

Qualify *;

GLAccountNo:

LOAD *;

SQL SELECT *

FROM dbo.vGL2LvlAcctDataByA;

UNQUALIFY *;

[#3]

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

[#5]

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]

[#6]

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.