I NEED TO ADAPT THE DVD using the inline below

[EmmaMark]

Data:
Load
    FirstSortedValue(Mesano, -Data) as Mesano,
    Codigocontabancaria,
    Date(Max(Data)) as Data,
    FirstSortedValue(Codigo, -Data) as Codigo,
    FirstSortedValue(Balance, -Data) as Balance
Group By Codigocontabancaria;
Load
    Mesano, 
    Codigocontabancaria, 
    Data, 
    Max(Codigo) as Codigo,
    FirstSortedValue(Balance, -Codigo) as Balance
Inline [
Mesano, Codigocontabancaria, Data, Codigo, Balance
"dez 2023", 107, "31/12/2023", 351289, 1638.05
"dez 2023", 107, "31/12/2023", 351288, -8361.95
"dez 2023", 108, "20/12/2023", 349958, 1638.05
"dez 2023", 108, "20/12/2023", 349957, -3641.95
"dez 2023", 108, "14/12/2023", 348936, 1638.05
"dez 2023", 106, "14/12/2023", 348935, 601.86
"dez 2023", 106, "13/12/2023", 348793, 1638.05
]
Group By Mesano, Codigocontabancaria, Data;

I NEED TO ADAPT THE DVD using the inline below ........................
Dados:
LOAD 
CODIGOCONTABANCARIA AS Codigocontabancaria, 
DATA AS Data, 
MonthName(DATA) as Mesano,
CODIGO AS Codigo, 

Balance

FROM
[C:\Users\vasco\Desktop\ProcessedData.qvd]
(qvd);

[Lisa_P]

What is the result you are looking for and what is the result you are getting ?

[EmmaMark]

I need to adapt an inline table for one by qvd not working

Help

It's working with inline but I can't put it via qvd

Dados:
LOAD 
CODIGOCONTABANCARIA AS Codigocontabancaria, 
DATA AS Data, 
MonthName(DATA) as Mesano,
CODIGO AS Codigo, 

Balance

FROM
[C:\Users\vasco\Desktop\ProcessedData.qvd]
(qvd);

Data:
Load
FirstSortedValue(Mesano, -Data) as Mesano,
Codigocontabancaria,
Date(Max(Data)) as Data,
FirstSortedValue(Codigo, -Data) as Codigo,
FirstSortedValue(Balance, -Data) as Balance
Group By Codigocontabancaria;
Load
Mesano, 
Codigocontabancaria, 
Data, 
Max(Codigo) as Codigo,
FirstSortedValue(Balance, -Codigo) as Balance;

desired result, but changing from inline to qvd table, I need to adapt the script is correct. I'm just not able to adapt.

Inline [
Mesano, Codigocontabancaria, Data, Codigo, Balance
"dez 2023", 107, "31/12/2023", 351289, 1638.05
"dez 2023", 108, "20/12/2023", 349958, 1638.05
"dez 2023", 106, "14/12/2023", 348935, 601.86

]

[henrikalmen]

Do you have a qvd to load the data from? Are you using Qlik Sense Desktop so that you are able to use a file path (C:\Users\vasco\Desktop\) in your load statement (at least I believe that's possible in QS Desktop, but creating a lib connection is recommended)? What is the error message that you are getting?

[EmmaMark]

It's good to get the solution to my problem here on the forum, but it was INline. Now I don't know how to change the inline to the table. I would just like to remove the inline and place the script via qvd. it is working inline. But I don't know how to adapt the qvd to the inline place

[EmmaMark]

the person who helped me here on the forum. reversed the direction, put the inline last and now I don't understand how to put my real table. I was just confused because I never put the solution and the subsequent table first. I need the qvd table first and the solution later.

[henrikalmen]

Please read my previous comment and try to answer the two questions there. I find it difficult to know how to help you based on the information you have given so far.

[EmmaMark]

Inline [ 
Mesano, Codigocontabancaria, Data, Codigo, Balance 
"dez 2023", 107, "31/12/2023", 351289 , 1638,05 
"dez 2023", 107, "31/12/2023", 351288, -8361,95 
"dez 2023", 108, "20/12/2023", 349958, 1638,05 
"dez 2023", 108, "20/12 /2023", 349957, -3641,95 
"dez 2023", 108, "14/12/2023", 348936, 1638,05 " 
dez 2023", 106, "14/12/2023", 348935, 601,86 
"dez 2023", 106 , "13/12/2023", 348793, 1638.05 
] 
Grupo Por Mesano, Codigocontabancaria, Data; 

Dados: 
LOAD 
CODIGOCONTABANCARIA AS Codigocontabancaria, 
DATA AS Data, 
MonthName(DATA) as Mesano, 
CODIGO AS Codigo, 

Balance 

FROM 
[C:\Users\vasco\Desktop\ProcessedData.qvd] 
(qvd);

It's the same thing, I just need to adapt the first to the second.

[henrikalmen · Accepted solution]

There's basically not much difference between inline load and loading from a qvd.

table1:
load fruit, price
inline [
fruit, price
apple, 10
]
;

table2:
load fruit, price
FROM [qvdfileaddress] (qvd)
;

You just more or less replace the iline statement with a from-statement.