SQL Syntax Help

[#1]

When you import tables from Excel and need to do a field name change you use an "as" function: for example

Division as "User Division"

What would the syntax be for changing field names from salesforce.come tables?

Please help!!

Thanx

[Anonymous]

Use This

[Division] as [User Division]

[#3]

Neither of these methods seems to be working for me

[Anonymous]

the keyword AS is QV keyword not SQL , so bebore u run SQL statemen ( SQL SELECT) and after

can transform with QV

Try a script like this..

Tabele:

LOAD

    XCDEL                         as XCDEL1,

    capitalize(trim(XDTAB)) as  XDTAB1;

SQL SELECT

    XCDEL,

    XDTAB

FROM .............;

[jagan]

Hi,

Use below script

TableName:

LOAD

     Id AS ID,

     [DGA_Account_Number__c] AS DGAAccountNumber;

SQL SELECT

          Id,

    DGA_Account_Number__c

FROM Account;

Regards,

Jagan.

[#6]

That worked!  Thank you all for your replies

[jagan]

Hi,

Close this Discussion by selecting "Correct Answer", if it solves your problem.  It helps others to find the solution for this type of scenarios.

Regards,

jagan.

[#8]

This was not my original question, so I cannot close this discussion as Answered