Create field with data

[alexvalqlik]

Regards,

I am using the 'Climber Selection Bar' extension and in the 'Initial Selection' property (Fig.1) I need the 'Sellers', I am currently entering them as Fixed data (Fig.2), but I need to be dynamic.

The information of the Sellers is in the field 'Nomb_Representante' of the table 'KNA1_Representantes'.

I must have a variable or generate a field that has the data.

KNA1_Representantes:

LOAD

    KUNNR                     as Cod_Representante,

    NAME1                     as Nombres_Representante,

    MID(KUNNR,5,10)&' '&NAME1 as Nomb_Representante

FROM [lib://Qvds_FI/KNA1_CLI_REP.qvd](qvd)

Where KTOKD='ZREP';

Thank you.

[Quy_Nguyen]

Hi Alex,

Try this:

KNA1_Representantes:
LOAD
    KUNNR                     as Cod_Representante,
    NAME1                     as Nombres_Representante,
    MID(KUNNR,5,10)&' '&NAME1 as Nomb_Representante
FROM [lib://Qvds_FI/KNA1_CLI_REP.qvd](qvd)
Where KTOKD='ZREP';

Temp:
Load Concat(Nomb_Representante,'|') as MatchField
Resident KNA1_Representantes;

Let vInit = Peek('MatchField',0,Temp);
Drop Table Temp;

Then use vInit in your Climber.

Best,

Quy

[alexvalqlik]

Thanks Quy Nguyen, it worked!

[Quy_Nguyen]

Glad it helped. If your question has been answered to your satisfaction, please mark it as correct.