Scripting Help

[vanderson009]

Hello guys,

I have 2 tables like below.

TableA :

Column1	Column2	Comment

Comment Column includes some Comment Sentence. Comment Sentence having some words like Column "Word" from TableB.

Those are having Word as frustrating or frustrated or frustration where i have to apply FLAG as CE negative,

Those are having Word as efficient or prompt or satisfied where i have to apply FLAG as CE positive and so on...

But the thing is that their is no linking between TableA and TableB.

TableB:

Tags	Words
CE negative	frustrating, frustrated, frustration
CE positive	efficient, prompt, satisfied
Staff poor	friendlier, rude, not pleasant

Please help me for this task....

-- Thanks and Regards,

Villyee Anderson

[vanderson009]

Hello Richard,

Please have look at image that i have posted here, which is from your QVW applicatation that i have marked as Helpful.

When i select CE_negative then "I felt really frustrated about my service" only this comment will show

and so on....

- Thanks

Villyee Anderson

[richard_pearce6]

Hi Villyee,

I see what you mean. I've updated the file to show how this could be acheived. An extra field has been incerted into 'Main 3' tab which adds the Tag value. This has also been added to the group by.

The result means you'll have a one to many link on your ID field now. So this table could hang off your main fact table.

Please let me know if you need anything else

Richard

[richard_pearce6]

QVW

[richard_pearce6]

Just noticed you have lines where all rows are zero, this can be removed by using a where statement on the aggregation reload

rangemax(Field1,Feild2,etc>0

// Sum up the results

TableA:
NoConcatenate
Load
ID
,Tags
,sum(CE_Negative) as CE_Negative
,sum(CE_Positive) as CE_Positive
,sum(Staff_Poor) as Staff_Poor
Resident TableA_Temp
Where RangeMax(CE_Negative,CE_Positive,Staff_Poor)>0

group by ID,Tags
;

Edited: this needs to be > 0 as you could find multiple words in the comments for the same tag

Richard