topic Load * , field name from SQL is this works? in QlikView

Load * , field name from SQL is this works?

harleen_singh — Thu, 22 Mar 2012 14:49:33 GMT

Hello

i have one question can we write statement like this?

[$(Companyname)]:

Load *,

'$(Companyname)' as Company;

SQL SELECT *

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

thanks

Harlin

Thu, 22 Mar 2012 15:03:29 GMT

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 — Fri, 30 Mar 2012 08:17:05 GMT

english please

SunilChauhan — Fri, 30 Mar 2012 08:33:03 GMT

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