Hi
I am extracting data from SQL Server getting Distinct Fund name
LOAD Distinct("Fund_Name");
SQL SELECT "Fund_Name"
FROM "FI_Dashboard".dbo."VR_Data"
WHERE "FUND_NAME" NOT IN ('NO_OF_FUNDS')
order by "Fund_Name";
=mid(Fund_Name, 1, index(Fund_Name, ' ')-1)
Using mid & index, I am getting the value from the Fund Name
ie., Axis Short Term Fund --> 'Axis'
But I am getting a blank field on Top (image attached). How to avoid this blank column.
Mukundan
