Load * , field name from SQL is this works?

[harleen_singh]

Hello

         i have one question can we write statement like this?

[$(Companyname)]:

Load *,

'$(Companyname)' as Company;

SQL SELECT *

FROM [$(databasename)].dbo.$(sqltablename);

thanks

Harlin

[#2]

hola

espero que esto te sea util.

Sugerencia. Crea una tercer variable de las variables del From, si tienes algun problema quita las comillas simples de tu expresión

Let From1 = ‘[’ & $(databasename) & ‘].dbo.’ & $(sqltablename);

[$(Companyname)]:

Load*,

$(Companyname) as Company;

SQLSELECT *

FROM$(From1);

Saludos

[harleen_singh]

english please

[SunilChauhan]

SARDAR JI MEANING OF ABOVE IS BELOW

hello

I hope this is useful.

Tip. Create a third variable From variables, if you have any problems removing single quotes from your expression

Let From1 = '[' & $ (databasename) & ']. Dbo.' & $ (Sqltablename);

[$ (CompanyName)]:

Load *,

$ (CompanyName) as Company;

SQLSELECT *

FROM $ (From1);

regards

YOU CAN EASILY FIND IN GOOGLE TRANSLATE