Can I use SQL syntax in the source column filter? That is, can I filter the data so that only values starting with A are imported by writing A% in the Source column filter field for that dimension?
Hi Bernard,
I don't believe you can do that. My suggestion is that you create another staging table that contains the filtered data and load that.
I would recommend using a view for the source table instead of new table.
Thanks, I added dealt with it in the database.
