TagIds:
LOAD
    TaskTagIds,
    
    TaskTagTaskId as TaskLink
FROM [lib://Engineering Dev:DataFiles/TagIds.qvd]
(qvd);


left join

LOAD
    TagId as TaskTagIds,
    TagName as TaskTagName,
   


if(TagName='C. R','C. R',
if(TagName='L A','L A',
if(TagName='D A','L A',
if(TagName= 'Design','Design')))) as TagPhase,


    
FROM [lib://Engineering Dev:DataFiles/Tags.qvd]
(qvd);