Create a new dimension

[samuel_brierley]

Hi all this should be a quick one,

I have lots of data tables that have identical dimensions but are from different sources, is is possible to add into the load script for example "site1 as Source" or Site2 as Source" then i can filter on Source.

thanks

[tresesco · Accepted solution]

I guess you meant flagging. Yes you can, like:

Load

          *,

          'Site1' as Flag

From <Source1>;

Load

          *,

          'Site2' as Flag

From <Source2>;

Now you get a single table(provided all the sources have same number of fields that are identical). Then you can filter accordingly using the Flag field.

[samuel_brierley]

Thanks you