'' AS ID: Returning values instead of Nulls

[helen_pip]

Hello

I have 3 QVW's, not all of which contain the same field names:

Main

Eye

MIU

Each QVW is stored into a QVD

In a seperate QVW, I load each QVD and concatenate the information together

I am in the process of trying to optimise my QVD's, so I am adding in additional fields dummy fields, to ensure every QVW has the exact same field names

I wish for these additional fields to just contain no data.  I have noticed though, that if I do a count on a dummy field, and all I wanted was a null value

How do I build a dummy field to contain null values?

Kind Regards

Helen

[marcus_malinow · Accepted solution]

Hi Helen,

you can simply use the Null() statement, for example

Null() as NullField

Marcus

[helen_pip]

Hello

Thank you!  This works for me

Thanks

Helen