Invalid expression

[Carina_RH]

Hi 

Trying to load the data but keep getting invalid expression. Out of ideas to try fix it.

Thanks!

[Kushal_Chawda · Accepted solution]

@Carina_RH  problem is in your group by. You can only write the columns which is part of that load. You cannot write the column name which is renamed in that load or any other column which is not part of that load

your Group by should be below

Group by Period,Konto,Motpart;

[MindaugasBacius]

Try adding the Period field to the GROUP BY section and remove the field that starts %...

[Carina_RH]

I think I tried all but that but it did the trick! Thanks!

[Carina_RH]

I think I tried all but that but it did the trick! Thanks!

[Carina_RH]

@Kushal_Chawda My visualization didn't work with this group so I tried removing Period all together but then I am back to invalid expression, any thoughts?

LOAD 

//Period,

    DATE(Date#(Period,'YYYYMMDD')) as D_Datum_dkey,

     Konto, 

     Motpart, 

     sum(Belopp) as Belopp,

     sum (Budget) as Budget

From $(vSekretessEkonomi)\F_Ekonomi_2023.qvd (qvd) 

group by Konto, Motpart;

[Kushal_Chawda]

@Carina_RH  you should include period in group by because you still have that field on which you are applying formatting function