topic Re: scripting in QlikView

scripting

Pujitha — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 4 files which I need to concatenate to one. In one file I have like

Name Opt loc Cod id dig Lb .Gop. ....... some other columns

code 0 0 24 1 exx ..... ..... .....

prof 1 0 43 2 xer .... ... ..

stud 0 0 34 3 iop .... ... ....

Another table:

loc Cod Lb id gop(as op) ..............here and so on other columns

diff data in Lb column

another table:

Et loc Cod Lb id

another table:

Et st status Lb id loc

I need to append all these tables to one pls let me know this clearly from start to end how to do. Please let me know asap

Re: scripting

Marcos_rv — Thu, 18 Jul 2019 21:02:04 GMT

try this:

table1:

load

name ,

opt ,

loc,

cod,

id,

dig,

lb,

gop

from table1.qvd;

concatenate(table1)

load

loc,

cod,

lb,

id,

gop(as op)

from table2.qvd;

concatenate(table1)

load

et,

loc,

cod,

lb as lb_table3,

from table3.qvd;

concatenate(table1)

load

et,

st,

status,

lb,

id,

loc

from table3.qvd;

now all the tables are going to be concatenated in a single table, now if you know that the keys in each table are unique, you could use a left join or join to join them, remember that Qlikview relates tables by field names, so You have to be careful not to have tables that generate 1 to many relationships.

regards!!!

Re: scripting

Pujitha — Fri, 19 Jul 2019 13:59:05 GMT

I need to join based on id. Because in remaining columns which are having same number there will be the repetition.So based on id we need do join all the 4 tables as one. Id is the unique key.Please let me know

Re: scripting

Marcos_rv — Fri, 19 Jul 2019 14:16:42 GMT

qualify *;

unqualify id;

table1:

load

name ,

opt ,

loc,

cod,

id,

dig,

lb,

gop

from table1.qvd;

table2:

join(table1)

load

loc,

cod,

lb,

id,

gop(as op)

from table2.qvd;

table3:

join(table1)

load

et,

loc,

cod,

lb as lb_table3,

from table3.qvd;

tabla4:

join(table1)

load

et,

st,

status,

lb,

id,

loc

from table4.qvd;

unqualify *;

Re: scripting

Brett_Bleess — Wed, 14 Aug 2019 14:29:45 GMT

Duplicate thread, see https://community.qlik.com/t5/QlikView-Scripting/Script/m-p/1603816#M95950 for other posts.

Regards,
Brett