Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
If(Len(Trim(mid(Fund_Name, 1, index(Fund_Name, ' ')-1))) > 0, mid(Fund_Name, 1, index(Fund_Name, ' ')-1))