I am loading data from excel sheet which is in arabic format including all the column name in arabic.
Below is my load script. I want to apply where clause to filter data on one column but due to arabic language I am unable to write where clause in the script.
LOAD "الشهر" "المستهدف حتى ديسمبر 2021م"
FROM [lib://DataFiles /Report/Report1.xlsx] (ooxml, embedded labels, header is 2 lines, table is XYZ) ;
Here I want to put the where condition as where 'الشهر <>'المجموع'
so here المجموع is my filter value الشهر is my column so I want the text direction to be reversed.
