Variable definition issue

[shyamcharan]

Hi Experts,

I do have a basic table and variables created as below:

Table:

LOAD * INLINE [

    CalYrMnthNum, ThisYLM, LastYLM

    201607, 201606, 201506

    201606, 201605, 201505

];

SET vThisYLM = Max({<CalYrMthNum={"$(=Max(CalYrMthNum))"}>}ThisYLM);

SET vLastYLM = Max({<CalYrMthNum={"$(=Max(CalYrMthNum))"}>}LastYLM);

However, When I try to use the variable as =$(vThisYLM) i do not get any result.

Can anyone suggest what mistake i am doing here?

Please find the attached document.

Regards,

Shyam.

[Anil_Babu_Samineni]

You have Date field like CalYrMnthNum

Buy, you using CalYrMthNum

[kaushiknsolanki]

Hi,

It is because you do not have same field name in Table and in Variable.

Your variable uses "CalYrMthNum"

Where as your field name is CalYrMnthNum.

Correct it and then try.

Regards,

Kaushik Solanki

[shyamcharan]

Hi Guys,

Thanks heaps for your responses.

Even after renaming the Field name still I have the same issue.

However, the issue seems to be around the $ sign in the load script.

I found a few tips in the link below.

Can I SET or LET a variable to include a $(=...)

Will try and find if any issues. Thanks again.

Regards,

Shyam.

[Anil_Babu_Samineni]

PFA

[sunny_talwar · Accepted solution]

Try this may be:

Table:

LOAD * INLINE [

    CalYrMnthNum, ThisYLM, LastYLM

    201607, 201606, 201506

    201606, 201605, 201505

];

LET vThisYLM = 'Max({<CalYrMnthNum={"$' & '(=Max(CalYrMnthNum))"}>}ThisYLM)';

LET vLastYLM = 'Max({<CalYrMnthNum={"$' & '(=Max(CalYrMnthNum))"}>}LastYLM)';

[shyamcharan]

Thanks Sunny.