topic Escape sequence in IF condition in Load Script. in App Development

Escape sequence in IF condition in Load Script.

LP27 — Sat, 16 Nov 2024 02:54:38 GMT

Hi Everyone,

I am trying to enter the below If condition in Load Script and it not working because of not using Escape Sequence.

if(today() >= [Calendar day] , 'Week' &' '&Week([Calendar day]) &'('& Year([Calendar day])&')' )

Could some one tell me best way to use the above condition.

Thanks in advance!

Re: Escape sequence in IF condition in Load Script.

TimvB — Mon, 23 Mar 2020 14:03:16 GMT

Assuming you need to create an extra field by using the if statement, if so, you need to drop the "=" character and use something like below:

TableName:

Load

[YourFields],

if(today() >= [Calendar day] , 'Week' &' '&Week([Calendar day]) &'('& Year([Calendar day])&')' ) as [New Field]

From <YourSource>;

Otherwise, please provide a clear explanation, i.e., the purpose, your expectation, sample dataset, etc.

Re: Escape sequence in IF condition in Load Script.

sunny_talwar — Mon, 23 Mar 2020 14:06:02 GMT

Can you share a script where this doesn't work? I don't see a need for escape sequence here.

Re: Escape sequence in IF condition in Load Script.

LP27 — Mon, 23 Mar 2020 14:27:36 GMT

Sunny,

I am trying to create date field "Calendar Day" into columns as week in Pivot table like shown below -

Week 1(2020)

Week 2(2020)

Week 3(2020)

Week 4(2020)

If I use the below condition in front end of scripting its working fine, but that slows down the table when loaded.

if(today() >= [Calendar day] , 'Week' &' '&Week([Calendar day]) &'('& Year([Calendar day])&')' )

So now I want to use this condition in load Script, when I use the above condition in Load script. It appears as -

Week()

and it sums all week.

So I thought escape sequence can act well in this case.

Re: Escape sequence in IF condition in Load Script.

sunny_talwar — Mon, 23 Mar 2020 15:00:00 GMT

I am not seeing any issues with your script... is you field [Calendar day] read as date?

Re: Escape sequence in IF condition in Load Script.

LP27 — Tue, 24 Mar 2020 12:30:46 GMT

Your correct!

[Calendar day] was not read as Date properly.

Hence I used this condition -

if(today()>=date#("Calendar day",'DD.MM.YYYY'), 'Week' &' '&Week(date#("Calendar day",'DD.MM.YYYY')) &'('& Year(date#("Calendar day",'DD.MM.YYYY'))&')' ) as Week_Cal