Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you try this:
Qualify *;
GLAccountNo:
LOAD *;
SQL SELECT *
FROM dbo.vGL2LvlAcctDataByA;
UNQUALIFY *;
Can you try this:
Qualify *;
GLAccountNo:
LOAD *;
SQL SELECT *
FROM dbo.vGL2LvlAcctDataByA;
UNQUALIFY *;
Can this be done with a crosstable load?
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
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]
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.