sql condition to qlik condition script

[nareshthavidishetty]

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'

,'NLL'

FROM $(vS_DatabasePrefix)D__Status

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

Thanks..

;

[olivierrobin]

hello

you can use concatenate

1 - load your qvd from $(vS_DatabasePrefix)D_Status

2 - add

concatenate(yourtable)

load * inline [

-1

,'NLL'

,'NLL'

];

[Peter_Cammaert]

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