Need help to merge multiple rows with one single row

Question

Please help me to solve the questions where i have a data called as A with one single line column as Total Amount

Another file called as B with multiple lines coulmn as Amount which will sum up to Total amount in file A.

i need to merge them to one file

i have Date and Description column as well , Date is common in both of the file.

please give me solution to get them merge

OTrieger · Answer

@kumaneh 
It will be hard to tell just from your description, but if you will pull the data in from both files and then ensure that you have same headers you can union all the data and then it will be merge, however I believe for a different solution, and as @Qiu  requested, we need at least screenshots on the 2 set of data and how it is expected to be merged.

Qiu · Answer

@kumaneh

Please provide sampe input and desired output dataset.