topic Re: To Combimed two Files in App Development

To Combimed two Files

Upali_Wijearatne — Sun, 03 Mar 2024 07:42:57 GMT

Hi Experts

In my Qv file I have loaded two tables (Table1 and Table1) as per Sc attached Below. In my 3rd Table I want to insert two columns(Purchase & Sale) and create a new table. In my new table (table 3) I want get 1st and 4th column from table 1. I want to sum data in table 2 (month wise) and inset into table 3 as 2nd and 3rd Column(Purchase & Sales). I am unable figure out how to do it. Kindly help me with the load script to do this

Re: To Combimed two Files

anat — Sun, 03 Mar 2024 08:15:13 GMT

load Date,BF,CF from table;

T1:

load Date,purchase,sales from table;

noconcatenate

left join(T)

T2:load monthend(Date) as Date,sum(purchase) as purchase,sum(sales) as sales resident T1:

drop table T1:

Re: To Combimed two Files

Upali_Wijearatne — Sun, 03 Mar 2024 08:38:54 GMT

Thanks

I get the below error when I try load data

my script is shown below please.

Kindly advise me

Re: To Combimed two Files

anat — Sun, 03 Mar 2024 09:42:28 GMT

remove "Noconcatenate" from the script

T:
load * Inline [
Date,BF,CF
1-1-2022,1,1

];
T1:
load * Inline [
Date,p,s
1-1-2022,2,3
1-2-2023,2,2
];

Left Join(T)
T2:
LOAD MonthEnd(Date) as Date,sum(p) as p,sum(s) as s Resident T1 Group by Date;
DROP Table T1;

Re: To Combimed two Files

Upali_Wijearatne — Sun, 03 Mar 2024 10:07:04 GMT

I tried with you sample code it does not return P & S Values please

Re: To Combimed two Files

anat — Sun, 03 Mar 2024 11:23:01 GMT

May be check date format

Load date(Date) as Date, BF, CF;
load * Inline [
Date,BF,CF
1-1-2022,1,1

];
T1:
load * Inline [
Date,p,s
1-1-2022,2,3
1-2-2023,2,2
];

Left Join(T)
T2:
LOAD date(MonthEnd(Date)) as Date,sum(p) as p,sum(s) as s Resident T1 Group by Date;
DROP Table T1;