Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
EmmaMark
Contributor III
Contributor III

I NEED TO ADAPT THE DVD using the inline below

 

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);

Labels (2)
1 Solution

Accepted Solutions
henrikalmen
Specialist II
Specialist II

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.

View solution in original post

8 Replies
Lisa_P
Employee
Employee

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

EmmaMark
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author


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
Specialist II
Specialist II

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.