Data from two tables

[spividori]

Hi.

I have two tables and I need to get to the Ventas table the value of the Price field in the table Costos, as shown in the image.

I need to do it in the script and with the following result

[#2]

Hi Sandro,

Try this script:

Directory;
Ventas:
LOAD Item,
      Codigo as VentasCodigo,
      Fecha as VentasFecha
FROM
Ventas.xlsx
(ooxml, embedded labels, table is Hoja1);


Directory;
Costos:
left keep (Ventas)
LOAD Item,
      Codigo as CostosCodigo,
      Precio,
      Fecha as CostosFecha
FROM
Costos.xlsx
(ooxml, embedded labels, table is Hoja1);

 

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[spividori]

HI.

Thanks, it's what I needed!

Regards.