Merger of two Input table' s & required output as given below after export (.csv) file

[mohitchugh]

                                                                                           Input_Table_A

ITEM	digit
A	5
B	10
C	15

                                                                                            Input_Table_B

Class	digit
E	9
F	9
G	6
H	6

Output ( After Export)

Today Input on 21-June-2020

Total Input= 30

Item wise-digit/Zero

C-15/0

B-10/0

A-5/0

Class wise-digit/Zero

E-9/0

F-9/0

G-6/0

H-6/0

[v-eachen-msft]

Hi @mohitchugh ,

You could use List.Sum() and DateTime.LocalNow() to get results.

Here is my test file for your reference. 

[mohitchugh]

Thanks for reply...

I see your given solution.  it's much nearest to required form of output.                                                                                                 And i used Table Visual for this input data but, not comes in required output. please suggest

Spoiler

Spoiler

 

[v-eachen-msft]

Hi @mohitchugh ,

You could share your expected output with file or screenshot here.

[mohitchugh]

Output in Excel or .CSV file ....like this