topic Re: date,mapping load in QlikView

date,mapping load

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

i have a following load inline table(1,2,3),i trying to get the out put in such a way that ,dates are same in all the table i need value feild should be added up i need to get 300 for each date,can i get the expression

table1:

LOAD * INLINE [

Date, Value1

13-07-2014 12:00:00 AM, 100

14-07-2014 12:00:00 AM, 100

15-07-2014 12:00:00 AM, 100

16-07-2014 12:00:00 AM, 100

17-07-2014 12:00:00 AM, 100

];

table2:

LOAD * INLINE [

Date, Value2

13-Jul-2014, 100

14-Jul-2014, 100

15-Jul-2014, 100

16-Jul-2014, 100

17-Jul-2014, 100

];

table3:

LOAD * INLINE [

Date, value

13/o7/2014, 100

14/o7/2014, 100

15/o7/2014, 100

16/o7/2014, 100

17/o7/2014, 100

];

output:

Date	Value
13-Jul-2014	300
14-Jul-2014	300
15-Jul-2014	300
16-Jul-2014	300
17-Jul-2014	300

Re: date,mapping load

Anil_Babu_Samineni — Fri, 22 Dec 2017 13:23:45 GMT

PFA

Re: date,mapping load

Frank_Hartmann — Fri, 22 Dec 2017 13:31:27 GMT

if you need it at script level then try following code:

table1:
Load * , Date(Date#(Date,'DD-MM-YYYY hh:mm:ss TT'),'DD-MM-YYYY') as Date_New,
Value1 as Value;;
LOAD * INLINE [
    Date, Value1
    13-07-2014 12:00:00 AM, 100
    14-07-2014 12:00:00 AM, 100
    15-07-2014 12:00:00 AM, 100
    16-07-2014 12:00:00 AM, 100
    17-07-2014 12:00:00 AM, 100
   
];


Concatenate
table2:
Load * , Date(Date#(Date,'DD-MMM-YYYY'),'DD-MM-YYYY') as Date_New,
Value2 as Value;;
LOAD * INLINE [
    Date, Value2
    13-Jul-2014, 100
    14-Jul-2014, 100
    15-Jul-2014, 100
    16-Jul-2014, 100
    17-Jul-2014, 100
   
];
Concatenate


table3:
Load * , Date(Date#(Replace(Date,'o','0'),'DD/MM/YYYY'),'DD-MM-YYYY') as Date_New,
value as Value;
LOAD * INLINE [
    Date, value
    13/o7/2014, 100
    14/o7/2014, 100
    15/o7/2014, 100
    16/o7/2014, 100
    17/o7/2014, 100
   
];
 NoConcatenate
 Final:

 Load Date_New, sum(Value) as Value Resident table1 Group by Date_New; DROP table table1;

Re: date,mapping load

vignesh_s — Fri, 22 Dec 2017 14:43:58 GMT

thanks

Re: date,mapping load

vignesh_s — Mon, 25 Dec 2017 11:45:02 GMT

since im using trail version of QV, im nt able to open the file u sent,can u give the expresion in text

Re: date,mapping load

Anil_Babu_Samineni — Mon, 25 Dec 2017 12:19:38 GMT

Script attached

And expression RangeSum(value,Value1,Value2)