Hi, can you share a sample app with dummy data?
In your syntax there are some small issues:
-in your from you have a ';' before your group by
-Also you mention that your error is [Sum of Txs Tot Cre] was not found and in your load statement you are using [Suma de Txs Tot Cre]
With a sample app it will be easier to help you.
it seems the file you posted is in a newer version of QV or i cannot open it, no prob.
As i can see you are creating a mapping that uses numbers as source and destination, you should verify that those numbers match and they have both same value and format.
You can try adding the third parameter to know when there's no match
ApplyMap('Ventas2',[Suma de Txs Tot Cre],'NO MATCH')
Also verify that the field you are using in the applymap must exists in your file [lib://Transbank/Sabana.xlsx]
Check the below example:
mapping load * inline [
3, three ] ;
ApplyMap('Map1',f4,'No Match') as f4Mapped
FROM [PathToMyFile] (ooxml, embedded labels, table is Tablas);
Hope this helps.
I need calculate this in the script
i dont know if is the best solution, I tried to resolve this whith
joins between the tables, but the results are wrong data
if([Venta Min]<=SumTSX2, Tasa,'-') as Prueba00,
if([Venta Max]<=SumTSX2, Tasa,'-') as Prueba01,
if([Vale Min]<=VarVtaTxs, Tasa,'-') as Prueba10,
if([Vale Max]<=VarVtaTxs, Tasa,'-') as Prueba11
sorry for my english