Problem with value into the field

[pgalvezt]

Hello!

I have to emulate a vlookup excel in QlikView fot that I have 5 Tables (3 Excel and 2 tables Visual Fox Pro).

First: When I load the visual Fox tables appears a date like 1899 and bring me a lot of data. (Out of memory Warning).

Second:  Im creating 2 fields "Homologo_Btcc11" and "Homologo_Bsc01". "Homologo_Bsc01 is done from script" was easy because the two fields cc_cli and rut both were in the same table (Bsc01).

"Homologo_Btcc11" was created like:  (Here join rut plus cc_cli) like 22345569872 without -digit verificator

TempTabla:

Load

  CC_Cli   as CC_Cli

  resident Clasificaciones;

Left Join(TempTabla)

Load

rut

Resident BTCC11; 

Left Join(BTCC11)

Load CC_Cli&''&rut as Homologo_Btcc11

resident TempTabla;

Drop Table TempTabla;

But when execute this appear a warning like "Out of virtual And/Or Logical memory"

I Attached a jpg file with the What I want to do...."Homologo_Btcc11" was created like expression but I need it like..... as "Homologo_Btcc11" into the script similar to "Homologo_Bsc01". So after that I can do the vlookup:

MapFecha_Protesto:
Mapping Load "Homologo_Bsc01",Fecha_Protesto Resident BSC01;

Join(Btcc11)
Load ,ApplyMap('MapFecha_Protesto',"Homologo_Btcc11",Null()) as FechaProtesto Resident Btcc11;

- So What I want is delete "1899" Value into the field and "Out of virtual And/Or Logical memory" is going to dissapear I think

- second I need to create this "Homologo_Btcc11".

I attached 2 qvs example for better comprehension I hope you can help m with this.

Thank you

[#2]

Replace

rut&ApplyMap('MapBttcc11_Bin',left(cuenta,3),Null())

with

text(ApplyMap('MapBttcc11_Bin',left(cuenta,3),Null()))&text(rut)

Regards,

Kiran.

[pgalvezt]

Nice but the 0000 they don't want to disappear. I tried to change the format number but nothing happened. first number would be 762266797 and no 76000002266797 See JPG file.

[#4 · Accepted solution]

try:

text(Num(ApplyMap('MapBttcc11_Bin',left(cuenta,3),Null()),'##'))&text(rut)

Just try to play around the number format and text functions.

Regards,

Kiran Rokkam.

[pgalvezt]

  Got it!!!!

text

(ApplyMap('MapBttcc11_Bin',Num#(left(cuenta,2)),Null()))&text(rut) as Homologo1,
Num#(left(cuenta,2))&rut as Homologo_Btcc11

,

nice,

Many Thanks Karin