Hi there,
I need to produce a dataset in CSV format that contains fields that are not in my table. These fields will be blank but some will populated with a value that will be required for all columns.
Is this possible to do 'on the fly' within the query itself or do I have to create dummy fields in my table? I would prefer the query option as otherwise everytime I generate the dataset I will have to add the dummy columns.
many thanks
Naz
I need to produce a dataset in CSV format that contains fields that are not in my table. These fields will be blank but some will populated with a value that will be required for all columns.
Is this possible to do 'on the fly' within the query itself or do I have to create dummy fields in my table? I would prefer the query option as otherwise everytime I generate the dataset I will have to add the dummy columns.
many thanks
Naz
