Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need help with doing this
I have this table :
Example:
LOAD
id,
group,
date,
sum(cant) as Cant,
sum(days) as Days
FROM ...
group by id, group, date;
Before this, i have three concatenates which add 3 new values.
and after that, i have to add new columns based in these previous values, so i use "resident"
Load
id,
group,
date,
sum(concatenate_value1) as concat1,
sum(concatenate_value2) as concat2
sum(concatenate_value1 + concatenate_value3) as concat 3
resident example
group by group by id, group, date;
But this isn't working, any idea with this ??
thanks !!
Could you attach the qvw?
I can't, sorry
Can you copy paste your full script here? Including your Concatenate tables script?
if you will provide sample data,we may help you in this surely.