Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using the below expression in script level.But its not working what is the problem
I am calculating the Max month related data is store into current2015count field.
if(Created_date = date(max(Created_date),'MMM') ,[2015 Count 1],) as current2015count
Hi Subbu,
As per Question, you are doing this by load statement.
If this is case, then you can't use aggregate functions in load statement without using group by clause.
But In your case using group by clause is not logical and will not either solve your problem.
So you first need to take a variable above this load statement and assign it value as max(Created_date) :
Let vMaxDate = max(Created_date).
Then in load statement write the variable instead of max(Created_date). like :
if(Created_date = date('$(vMaxDate)','MMM') ,[2015 Count 1],) as current2015count
This will solve your concern.
Hi,
You need to use Group by if you are using Max() in Load script, attach some sample data and let us know your required output.
Regards,
Jagan.
Hi
I suggest you attach the load script for the table that contains the line in question.Sample data and a complete load script would also help.
Jonathan
can you please attach the app with sample data??
Hi,
this is my sample data.
Name | subject | Date | value Count | marks |
mike | English | 31-Jan-15 | 0 | 20 |
mike | maths | 31-Jan-15 | 0 | 21 |
mike | science | 31-Jan-15 | 0 | 24 |
mike | social | 31-Jan-15 | 0 | 25 |
hari | English | 31-Jan-15 | 2 | 22 |
hari | maths | 31-Jan-15 | 2 | 24 |
hari | science | 31-Jan-15 | 2 | 26 |
hari | social | 31-Jan-15 | 2 | 27 |
john | English | 31-Jan-15 | 4 | 18 |
john | maths | 31-Jan-15 | 4 | 20 |
john | science | 31-Jan-15 | 4 | 29 |
john | social | 31-Jan-15 | 4 | 30 |
sai | English | 31-Jan-15 | 1 | 20 |
sai | maths | 31-Jan-15 | 1 | 22 |
sai | science | 31-Jan-15 | 1 | 24 |
sai | social | 31-Jan-15 | 1 | 26 |
mike | English | 28-Feb-15 | 0 | 20 |
mike | maths | 28-Feb-15 | 0 | 21 |
mike | science | 28-Feb-15 | 0 | 24 |
mike | social | 28-Feb-15 | 0 | 25 |
hari | English | 28-Feb-15 | 2 | 22 |
hari | maths | 28-Feb-15 | 2 | 24 |
hari | science | 28-Feb-15 | 2 | 26 |
hari | social | 28-Feb-15 | 2 | 27 |
john | English | 28-Feb-15 | 4 | 18 |
john | maths | 28-Feb-15 | 4 | 20 |
john | science | 28-Feb-15 | 4 | 29 |
john | social | 28-Feb-15 | 4 | 30 |
sai | English | 28-Feb-15 | 1 | 20 |
sai | maths | 28-Feb-15 | 1 | 22 |
sai | science | 28-Feb-15 | 1 | 24 |
sai | social | 28-Feb-15 | 1 | 26 |
and my expected design is:
Name | Baseline Valuecount | Current value count | Subject | Baseline Marks | Current Marks |
mike | 0 | 0 | English | 20 | 20 |
maths | 21 | 21 | |||
science | 24 | 24 | |||
social | 25 | 25 | |||
hari | 2 | 2 | English | 22 | 22 |
maths | 24 | 24 | |||
science | 26 | 26 | |||
social | 27 | 27 | |||
john | 4 | 4 | English | 18 | 18 |
maths | 20 | 20 | |||
science | 29 | 29 | |||
social | 30 | 30 | |||
sai | 1 | 1 | English | 20 | 20 |
maths | 22 | 22 | |||
science | 24 | 24 | |||
social | 26 | 26 |
Plz help me in this part.
plz write the discussion in discussion window only.
Hi,
this is my sample data.
Name | subject | Date | value Count | marks |
mike | English | 31-Jan-15 | 0 | 20 |
mike | maths | 31-Jan-15 | 0 | 21 |
mike | science | 31-Jan-15 | 0 | 24 |
mike | social | 31-Jan-15 | 0 | 25 |
hari | English | 31-Jan-15 | 2 | 22 |
hari | maths | 31-Jan-15 | 2 | 24 |
hari | science | 31-Jan-15 | 2 | 26 |
hari | social | 31-Jan-15 | 2 | 27 |
john | English | 31-Jan-15 | 4 | 18 |
john | maths | 31-Jan-15 | 4 | 20 |
john | science | 31-Jan-15 | 4 | 29 |
john | social | 31-Jan-15 | 4 | 30 |
sai | English | 31-Jan-15 | 1 | 20 |
sai | maths | 31-Jan-15 | 1 | 22 |
sai | science | 31-Jan-15 | 1 | 24 |
sai | social | 31-Jan-15 | 1 | 26 |
mike | English | 28-Feb-15 | 0 | 20 |
mike | maths | 28-Feb-15 | 0 | 21 |
mike | science | 28-Feb-15 | 0 | 24 |
mike | social | 28-Feb-15 | 0 | 25 |
hari | English | 28-Feb-15 | 2 | 22 |
hari | maths | 28-Feb-15 | 2 | 24 |
hari | science | 28-Feb-15 | 2 | 26 |
hari | social | 28-Feb-15 | 2 | 27 |
john | English | 28-Feb-15 | 4 | 18 |
john | maths | 28-Feb-15 | 4 | 20 |
john | science | 28-Feb-15 | 4 | 29 |
john | social | 28-Feb-15 | 4 | 30 |
sai | English | 28-Feb-15 | 1 | 20 |
sai | maths | 28-Feb-15 | 1 | 22 |
sai | science | 28-Feb-15 | 1 | 24 |
sai | social | 28-Feb-15 | 1 | 26 |
and my expected design is:
Name | Baseline Valuecount | Current value count | Subject | Baseline Marks | Current Marks |
mike | 0 | 0 | English | 20 | 20 |
maths | 21 | 21 | |||
science | 24 | 24 | |||
social | 25 | 25 | |||
hari | 2 | 2 | English | 22 | 22 |
maths | 24 | 24 | |||
science | 26 | 26 | |||
social | 27 | 27 | |||
john | 4 | 4 | English | 18 | 18 |
maths | 20 | 20 | |||
science | 29 | 29 | |||
social | 30 | 30 | |||
sai | 1 | 1 | English | 20 | 20 |
maths | 22 | 22 | |||
science | 24 | 24 | |||
social | 26 | 26 |
Plz help me in this part.
plz write the discussion in discussion window only.
Hi,
this is my sample data.
Name | subject | Date | value Count | marks |
mike | English | 31-Jan-15 | 0 | 20 |
mike | maths | 31-Jan-15 | 0 | 21 |
mike | science | 31-Jan-15 | 0 | 24 |
mike | social | 31-Jan-15 | 0 | 25 |
hari | English | 31-Jan-15 | 2 | 22 |
hari | maths | 31-Jan-15 | 2 | 24 |
hari | science | 31-Jan-15 | 2 | 26 |
hari | social | 31-Jan-15 | 2 | 27 |
john | English | 31-Jan-15 | 4 | 18 |
john | maths | 31-Jan-15 | 4 | 20 |
john | science | 31-Jan-15 | 4 | 29 |
john | social | 31-Jan-15 | 4 | 30 |
sai | English | 31-Jan-15 | 1 | 20 |
sai | maths | 31-Jan-15 | 1 | 22 |
sai | science | 31-Jan-15 | 1 | 24 |
sai | social | 31-Jan-15 | 1 | 26 |
mike | English | 28-Feb-15 | 0 | 20 |
mike | maths | 28-Feb-15 | 0 | 21 |
mike | science | 28-Feb-15 | 0 | 24 |
mike | social | 28-Feb-15 | 0 | 25 |
hari | English | 28-Feb-15 | 2 | 22 |
hari | maths | 28-Feb-15 | 2 | 24 |
hari | science | 28-Feb-15 | 2 | 26 |
hari | social | 28-Feb-15 | 2 | 27 |
john | English | 28-Feb-15 | 4 | 18 |
john | maths | 28-Feb-15 | 4 | 20 |
john | science | 28-Feb-15 | 4 | 29 |
john | social | 28-Feb-15 | 4 | 30 |
sai | English | 28-Feb-15 | 1 | 20 |
sai | maths | 28-Feb-15 | 1 | 22 |
sai | science | 28-Feb-15 | 1 | 24 |
sai | social | 28-Feb-15 | 1 | 26 |
and my expected design is:
Name | Baseline Valuecount | Current value count | Subject | Baseline Marks | Current Marks |
mike | 0 | 0 | English | 20 | 20 |
maths | 21 | 21 | |||
science | 24 | 24 | |||
social | 25 | 25 | |||
hari | 2 | 2 | English | 22 | 22 |
maths | 24 | 24 | |||
science | 26 | 26 | |||
social | 27 | 27 | |||
john | 4 | 4 | English | 18 | 18 |
maths | 20 | 20 | |||
science | 29 | 29 | |||
social | 30 | 30 | |||
sai | 1 | 1 | English | 20 | 20 |
maths | 22 | 22 | |||
science | 24 | 24 | |||
social | 26 | 26 |
Plz help me in this part.
plz write the discussion in discussion window only.
currentcount means current month data baselinecount means jan month data it is fixed one
currentcount means current month data baselinecount means jan month data it is fixed one.
currentcount means current month data baselinecount means jan month data it is fixed one