topic Re: Load data from database using concatination in QlikView

Load data from database using concatination

Sun, 27 Dec 2015 13:43:10 GMT

Hi all;

i work with database Sqlserver in our server , i succeded to have connction between Qlikview and Data base,

I selected the values that i want to load like :

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False; ..........;

SQL SELECT

code1,code2

from ......

i want to concatinate these two code like :

SET Verbatim = 1;

LOAD Distinct Text(code1&code2) as Concat

FROM database.table

how do i do for loading this COncat please

thanks all;

Re: Load data from database using concatination

swuehl — Sun, 27 Dec 2015 17:29:08 GMT

Not sure if I understand what you are finally trying to achieve, maybe something like this using a SQL query and a preceding LOAD:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False; ..........;

SET Verbatim = 1;

LOAD Distinct Text(code1&code2) as Concat;

SQL SELECT

code1,code2

FROM database.table;

Re: Load data from database using concatination

Kushal_Chawda — Sun, 27 Dec 2015 17:33:56 GMT

try this

Load *,

code1&'-'&code2 as Concat;

SQL SELECT

code1,code2

from Table;

Re: Load data from database using concatination

Sun, 27 Dec 2015 17:36:04 GMT

hi ,i used this script

SET Verbatim = 1;

LOAD Distinct Text(code1&code2) as Concat

FROM excel file to load a distinc concatinat values

but now i work with database sqlserver but not an excel file

i want to use a load function with this database ,its possible? if no how do i do for getting the concatinate distinc values

thanks

Re: Load data from database using concatination

Sun, 27 Dec 2015 17:39:32 GMT

hi colegue

i tried it but it seem an error message that say: it didn't know code1 and code2

other proposition

thanks

Re: Load data from database using concatination

Mon, 28 Dec 2015 07:17:22 GMT

an error message code1 not found field

Re: Load data from database using concatination

Anonymous — Mon, 28 Dec 2015 07:27:36 GMT

Does Code1 & Code2 field exist in your database table from which you are fetching these fields??

If yes, may be case sensitivity issue?

Re: Load data from database using concatination

Mon, 28 Dec 2015 07:35:12 GMT

good morning Balraj

yes , it does , they exit in my database , when i use only with SQL select , , i dont have any probléme or error

like :

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=.....;Initial ........

SQL SELECT

code1,

code2

from data base.table;

i dont any probléme here, but when i use this script:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=.....;Initial ........

Load *,

code1&'-'&code2 as Concat;

SQL SELECT

code1,code2

from Table;

i have an error message that these field not found or indifined field

Re: Load data from database using concatination

Mon, 28 Dec 2015 09:19:18 GMT

resolved

Re: Load data from database using concatination

MayilVahanan — Mon, 28 Dec 2015 09:23:45 GMT

Can you able to share the screenshot for your script and error message.

Re: Load data from database using concatination

Mon, 28 Dec 2015 09:28:17 GMT

probléme resolved , i used in to load an original name from SQL select , but in select sql i used renemad field

thanks brother

Re: Load data from database using concatination

oknotsen — Mon, 28 Dec 2015 09:29:13 GMT

Please flag the Correct Answer and possible Helpful answer to close this topic. Thank you.

Re: Load data from database using concatination

Mon, 28 Dec 2015 09:42:43 GMT

probléme resolved ,

i used in to load an original name from SQL select , but in select sql i used renemad field

i wish that helpful for other

thanks