Space in fields within Data Island

[#1]

Hi All,

I would appreciate if someone could help please.

I have a data island created from another filed:

Comparison_TradingG:

LOAD

TRADING_GROUP_DESCRIPTION as Comparison_TradingG,

Resident CIRR_MEASURES_WITH_DETAILS;

But the problem is the fileds with this table has spaces in the names and i am not shure how to trim these, as there is no data showing in my expresions.

Regards,

Redha

[Jason_Michaelides]

Maybe try:

Comparison_TradingG:

LOAD

PurgeChar(TRADING_GROUP_DESCRIPTION,' ') as Comparison_TradingG,

Resident CIRR_MEASURES_WITH_DETAILS;

Hope this helps,

Jason

[#3]

Hi,

It gives a red line under like this:

Resident CIRR_MEASURES_WITH_DETAILS;

Redha

[CELAMBARASAN]

Hi,

     Can you post that full load script of that particular table?

Celambarasan

[Miguel_Angel_Baeyens · Accepted solution]

Hi Redha,

There is a trailing comma that what is causing the error:

Comparison_TradingG:
LOAD
Trim(PurgeChar(TRADING_GROUP_DESCRIPTION, ' ')) as Comparison_TradingG // no trailing comma here
RESIDENT CIRR_MEASURES_WITH_DETAILS;

Hope that helps.

Miguel

[#6]

Hi,

Thank you for your help as it did work perfect.

I wounder if you can help in something else?

When I select one filed from the data islnad is fine but when I have a multiple selection it doesn't.

I had added this as a Varaible =CHR(39)&CONCAT(Comparison_TradingG,CHR(39)&','&CHR(39))&CHR(39)

it works but very slow.

is there a diffrent way to get the data island to calculate accourding to whats selected, I mean multiple selection?

Regards,

Redha

[CELAMBARASAN]

Hi,

     Check with this

     =if(GetSelectedCount(Comparison_TradingG)>0,CHR(39)&CONCAT(DISTINCT Comparison_TradingG,CHR(39)&','&CHR(39))&CHR(39),'*')

Celambarasan

[#8]

Hi,

Thank you that worked perfectly.

Redha