topic sql script in qlikview in QlikView

sql script in qlikview

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

How to convert SQL alter and update statement in qlikview

like e.g.

1.....

Alter table abctemp ADD [Code] varchar(50);

Alter table abctemp ADD [rion] varchar(50);

Alter table abctemp ADD [ID] varchar(2);

2....

UPDATE A

SET CODE = [ Value ]

FROM abctemp A

LEFT OUTER JOIN IDEM B ON A.Code = B.[No_]

UPDATE A

SET rion = [Name] FROM abctemp A

LEFT OUTER JOIN IDEM B ON A.Code = B.[No_]

UPDATE a set ID = 1 FROM abctemp a where a. rion =xyz'

Re: sql script in qlikview

Anonymous — Fri, 03 Feb 2017 09:27:19 GMT

You just add the field, based on left join.

2. left join (abctemp)

Load No_ as Code,

[ Value ] as CODE,

Name as rion

resident IDEM;

resident or From SQL select * from IDEM; if you are reading directly from database.

left join(abctemp)

Load No_ ,

1 as ID

resident abctemp

where rion='xyz';

If you want to update again, once that are defined in the table, use this:

Step 1:

rename field ID as ID_old

left join (A)

Load Key, -- the one from join

ID_new

resident B;

drop table B;

Step2:

Noconcatenate

Temp:

Load *, if( isnull(ID_new), ID_old, ID_new) as ID

Resident A;

Drop field ID_new, ID_old;

Best regards,

Cosmina

Re: sql script in qlikview

Kushal_Chawda — Fri, 03 Feb 2017 09:28:03 GMT

Can you please share the table structure of Table IDEM & abctemp ?