I am trying to calculate difference between the count of records using the below script and receiving warning during validation. But No issue with output
$source_count = sql('DATASTORE','select count(*) from Source Table');<br>$filter1_count = sql...
I need to compare data from two files (Preload File vs Post load). I can stage both files in two different template tables. How can we compare a record row by row from two tables?
I have a table with multiple records with same account No like
A/C No Company Code Currency Code Active Fiscal Year Billable
1001 10 EUR 1 2022 1
1001 20 USD 1 2022 1
1001 10 CHN 0 2022 1
1001 10 EUR 1 2022 0
1001 10 EUR 1 2022 1
1001 1...
Hi All,
I have a Table with 10 Columns
I need to Sum 2 Columns using Grouping on 4 Columns.
I am Trying to achieve this by Query Transform
Step 1: Taken 6 columns into a New Query and applied Group By under GROUP BY tab for 4 columns and ...
Hi Dominik,I am using Windows 11 to run the PLC emulator, but I keep getting the error message for Bridge"Error: Could not find or load main class pl.sapusers.mfsplc.bridge.Bridge"and for SIM"Exception in thread "AWT-EventQueue-0" java.lang.NoClassDe...