HI,
I am using the SQL connector and have a table where I want to count the total sum of the column 'InvAmt' filtered by the 'FileHeaderID' as shown n the picture attached.
Is it possible to achieve using Get Rows V2 ?
Thanks,
Hi,
Thank for your suggestion. I didn`t know about this tool until now. It is very useful.
If you use the SQL Server action "Transform data using Power Query" you can do most anything.