I would suggest you to do an applymap since you have only 2 fields. Something like this.
Applymap is faster and rules out errors as well.
Claims_Submitted_2018: Mapping Load ENCID, Total_Charges as "ENCID Total Charges"; SQL SELECT [ENCID], SUM([Trans]) AS Total_Charges FROM [patientledgerreport] AND [ITEMTYPE] IN ('C') Group By [ENCID]; store Claims_Submitted_2018 into [lib://BACKUP/Claims_Submitted_2018.csv] (txt); Claims_Submitted_2018: LOAD PracticeName, ENCID as "Claim ID", "Transaction Date" as "Date Submitted", LocationName, Applymap('Claims_Submitted_2018',ENCID,0) as "ENCID Total Charges"; SQL SELECT * FROM [patientledgerreport] WHERE [Transaction Date] BETWEEN '01-01-2018' AND '01-31-2018' AND [ITEMTYPE] IN ('F-C') AND ([Description] NOT LIKE '%REFILE%' AND [Description] NOT LIKE '%CROSSOVER%');
I need some help as well.
I have 3 tables which have all been loaded and have various fields.
But now I wanty to make use of a few field form these tables by creating a new table through a join.
First all the tables are loaded, have gone through the select statements.....
Below is my load though of.
[fullName] AS [fullName],
[taskType] AS [taskType],
[StartTime] AS [StartTime],
[maufacturingOrderID] AS [ManufacturingOrderID]
Left Join (Activities_join)
[maufacturingOrderID] AS [ManufacturingOrderID],
[ProductName] AS [ProductName],
[quantity] AS [quantity]
[ProductID] AS [ProductID],
[ProductName] AS [ProductName]
DROP Table Products_Table;
DROP Table Order_Table;