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
I need to implement the same logic while we extract the data from QVD.
you can use concatenate
1 - load your qvd from $(vS_DatabasePrefix)D_Status
2 - add
load * inline [
Are you sure that the original SQL statement does work? The first SELECT has no column specification.