Problem in Right Join

I am using right join for getting data from two tables. The custom formula works fine when I click save and validate but it just keeps loading while preview. If anyone can help then it would be great. This is a bit urgent.

Thanks in advance

Hi @prasadsawant74,

Yes currently merging of the 2 Sheets directly into TableGrid control is not supported.

You can however add a JSON store control and move the RIGHTJOIN formula to this JSON store control and than in your TableGrid control give a reference of Uniquename of this JSON Store control and Save and Validate.

Now On Preview, you should be able to view your data.

Hope this Helps!