topic Re: sql condition to qlik condition script in QlikView

sql condition to qlik condition script

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

Hi,

We have used the below script during the extraction of data from database.

And instead of using this condition in raw extract we planned to implement the logic during qvd exaction.

logic/Query during the data extraction :

Select FROM $(vS_DatabasePrefix)D_Status

union

SELECT

-1

,'NLL'

FROM $(vS_DatabasePrefix)D__Status

I need to implement the same logic while we extract the data from QVD.

Thanks..

;

olivierrobin — Tue, 26 Jun 2018 07:07:56 GMT

hello

you can use concatenate

1 - load your qvd from $(vS_DatabasePrefix)D_Status

2 - add

concatenate(yourtable)

load * inline [

-1

,'NLL'

];

Peter_Cammaert — Tue, 26 Jun 2018 07:17:21 GMT

Are you sure that the original SQL statement does work? The first SELECT has no column specification.